在Power BI中显示预先计算的非加工分层数据
我有分层数据,其中已经从源头计算出父值。我想在Power BI中以级别选择等进行交互显示这些数据
。 =“ nofollow noreferrer”>
什么是源数据的最佳格式和哪种视觉使用?
理想的解决方案:
- 灵活的级别数量
- 尽可能少,
我已经尝试了分层切片机,但我无法为其提供值列。矩阵需要一个我没有的聚合功能。
I have hierarchical data where parent values are already calculated figures from the source. I would like to show those data interactively in Power BI with level selection etc. The data can be represented as 'distinct customers', for example:
What would be the best format of source data and which visual to use?
Ideal solution:
- flexible number of levels
- as little DAX as possible
I already tried hierarchical slicer but I cannot provide values column to it. Matrix demands a function for aggregation which I don't have.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
矩阵视觉效果,这为您提供相同类型的结构。
您会将控股公司添加到公司,然后将帐户经理添加到行部分中。然后,您喜欢自己喜欢的这种视觉效果
The matrix visual, this give you the same type of structure.
You would add holding company then the company then the account managers into the row section. You then style this visual how ever you like