Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We currently run an Azure Analytics Services tabular model (level 1500) which has a number of hierarchies defined. Each is a ragged hierarchy of up to 10 levels all with the [Hide Members] setting set to 'Hide blank members' (as per https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-supplemental-lesson-ragg...)
However, wherever the hierarchy is used in the Power BI desktop (matrix, slicer, etc) blank rows continue to be shown where hierarchy levels are blank.
Excel seems to honor this setting, but it seems Power BI Desktop does not. Is this the case?
I did find this reference from 4 years ago, but is this still valid?
https://community.powerbi.com/t5/Desktop/2017-Ragged-Hierarchies-supported-in-Power-BI/m-p/439184
I know DAX Patterns has a solution using DAX, and this might have to be my fallback, but I would prefer to use the model setting if that can be honored by the desktop.
Thanks
Solved! Go to Solution.
Hi, @Mixednuts
The final appearance is subject to the presentation of powerbi.
Best Regards,
Community Support Team _ Janey
Hi, @Mixednuts
The final appearance is subject to the presentation of powerbi.
Best Regards,
Community Support Team _ Janey
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |