Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a question about the SSAS 2017 tabular hierarchy behavior in Power BI desktop.
In SSAS, I use the hide Blank Member property in my hierarchy.
When I query the cube in Excel, it works well and my blank members are not displayed.
In Power BI in Direct Query Mode, I use my SSAS hierarchy in a tablix component, and my Blank Member is displayed.
Is there a way to avoid this?
Thanks for your help!
Pierre
I don't think this is supported yet in Power BI. You probably have to exclude the blank manually using visual level filters.
User | Count |
---|---|
85 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
106 | |
96 | |
90 | |
79 | |
68 |