多个切片器中的动态选择维度在Power BI中?

huangapple go评论106阅读模式
英文:

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.

多个切片器中的动态选择维度在Power BI中?

答案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

huangapple
  • 本文由 发表于 2020年1月6日 14:35:47
  • 转载请务必保留本文链接:https://go.coder-hub.com/59607682.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定