Hiding Column While Drill Down

[srlabhe123]

Hi All,

I have a crucial scenario here where I would have to drill down but when I do it to next level the resulted columns chnages.

For ex in attached mockup when you are at level 1 you shoudl be able to see columns marked on Level 1.

Then when you drill down to Level 2 the resulted columns should be displaying which is not on Level 1.

Similarly from Level 2 to Level 3.

So can we hide the columns when drill down from Level 1-> Level 2 and Level 2 -> level 3

Appreciate workarounds or alternative for this mockup too.

Thanks

[v-yulgu-msft]

Hi @srlabhe123 ,

As a workaround, you can turn off "Stepped layout" and turn on "+/- icons" under Row headers pane for a Matrix visual.

Best regards,

Yuliana Gu

[srlabhe123]

But that wont have me different set of columns displayed on next level . Please see the mockup provided

[v-yulgu-msft]

Hi @srlabhe123 ,

Unfortunately, such a format is not achievable in Power BI now.

Best regards,

Yuliana Gu