Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SSAS 2017 Tabular hierarchy

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

 

Need Help

1 Reply

  • AkhilAshok's avatar
    AkhilAshok
    Solution Sage
    7 years ago

    I don't think this is supported yet in Power BI. You probably have to exclude the blank manually using visual level filters.