topic Re: Matrix with drill down : Display certain rows based on slicer selection in DAX Commands and Tips

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

swasim — Fri, 04 Oct 2024 20:29:34 GMT

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

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

lbendlin — Sat, 05 Oct 2024 01:01:08 GMT

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

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

snarasi_83 — Sat, 05 Oct 2024 14:54:43 GMT

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

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

Anonymous — Mon, 07 Oct 2024 02:54:32 GMT

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