PowerBI : MATRIX dynamic Row based on slicer selection

[snarasi_83]

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 request is for :

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.

Attcached .PBIX file : https://drive.google.com/file/d/1ail3x_sA2c9bQoEmH3_FLiZ1DRDJ4vm4/view?usp=sharing

Quick Snapshot of the visual.

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

[Anonymous · Accepted solution]

Thanks for the reply from @lbendlin.

Hi @snarasi_83 ,

You can dynamically control which hierarchies are displayed through the field parameter slicer.
medium.com

However, if you want to dynamically control the display of the matrix rows by influencing the selection of this slicer by another slicer selection A or B. This is not possible.

The slicer can only filter other visuals, but can not control the selections in other slicers.

Therefore, there is no way to control the display of the matrix rows by selecting A or selecting B of the slicer and thus, as @lbendlin  said, it is recommended that you submit this idea.
Microsoft Fabric Ideas

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

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