英文:
Dynamic selection Dimensions in multiple slicers in power bi?
问题
在报表中,我有五个切片器。每个切片器都包含相同的字段。例如(类别、子类别、城市、细分、位置、销售、折扣、数量),并且在切片器下面有一个表格。当用户选择第一个切片器:类别时,表格中应显示类别;第二个切片器:子类别应显示在第二行的子类别;第三个切片器:销售应根据类别和子类别的销售显示销售值。
如果用户希望在表格中固定显示两个度量值,用户可以在切片器中选择维度。
这在Power BI中是否可行?
请有人帮助我解决这个问题。在我的组织中,他们使用MicroStrategy报告,我们需要在Power BI中复制相同的功能。
英文:
Let say i have one table that table contains multiple measures and dimensions.
Requirement : In the report i have five slicers . Each slicer having same fields.<br><br> Example(category, sub-category, city, segment, location, sales, discount,quantity) and i have one table below the slicers, when user selected 1st slicer : category it has to display category in table, 2nd slicer : sub- category it has to display in second row sub- category ,3rd : sales it has to display sales value as per category and sub category sales.
if user want two fixed measures in the table. as per this measures user will select the dimensions in the slicers
is this possible in power bi ?
please anyone help me in this problem.in my organization they use micro-strategy report this same functionality we have to replicate in power bi.
答案1
得分: 1
这是中文翻译的部分:
"这不是直接可能的,因为在Power BI中不是这样工作的方式。不要使用多个拆分器,而是构建一个层次结构,然后使用一个单一的HierarchySlicer。"
英文:
It isn't directly possible, because this isn't the way it works in Power BI. Instead of having multiple splicers, build an hierarchy and use one single HierarchySlicer for that.
答案2
得分: 0
谢谢你的回复,我非常感激。根据层次结构选择,用户只能看到我们提供的订单。
但在我的场景中,用户可以选择他想在切片器中看到的任何一个维度,这将反映在下面的表中,根据维度的度量值会显示出来。
我已经实现了这种方式,但大量的Power BI无法处理,我的方法对于大数据不正确。小数据可以处理这种方法,我需要更多的方法来处理10亿数据。谢谢。
英文:
Thank you so much for your rely,i really appreciated, as per hierarchy selection user can see only order which we gave.
But in my senoriO user can selection any one of the dimension which he want see in slicers that will reflect in below table as per dimension measures will show the values.
This way i achieved but large amount of volume power bi not handling,my approach is not correct way for huge data . small data can handle this approach.i need more approches to handle 1 billon data . thank you enter image description here
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论