Show different hierarchy levels for specific attributes (like in Excel)

[Anonymous]

I would like to get an overview of my P&L by using the Matrix-visual.

I would like to drill down to specific atttributes, while leaving other closed. Thus, I would like to see certain attributes on level 1 in my hierarky, while for two of my level 2 attributes, I would like to drill down to level 3.

I cannot figure out if this is possible my using Power BI?

Can someone help?

This is the view I would like to have in Power BI:

This is the view I am getting (too many attributes on lower levels are shown.)

NB - I do not want to red to be shown.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Please vote on this idea: matrix-collapse-expand-buttons. Maybe we can have it in the near future.

Best Regards!

Dale