Matrix with drill down : Display certain rows based on slicer selection

[swasim]

I have a matrix table with level 2 , level 3 and level 4 in rows with drilldown option enabled, (Expand to next level using +icon) and product in column and Total in values, added a columnn BG in slicer.

The ask is :

• If i select value A from the slicer i want level 2 and level3 values should display and level 4 should not be displayed in the matrix row. Level 2 should drill down to level 3.

• If i select value B from the slicer i want level 3 and 4 should display and level 2 should not be displayed in the matrix row.

Level 3 should drilldown to level 4.

Quick Snapshot of the visual.

Please help me. Any solution with calculated columns or measures works 

[Anonymous]

Hi @swasim ,

I'm afraid this may not be possible, but you could consider designing options A and B as two separate navigation buttons. Each button would navigate to different screens: one displaying a visual with LV2 and LV4, and the other displaying a visual with LV3 and LV4.

Best Regards,

Bof

[lbendlin]

You cannot currently influence the expand/collapse feature programmatically.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[snarasi_83]

Thanks. @lbendlin  got it . any power Bi hack and tricks to accomplish this ? using Bookbark and any other option without programming.