Forum Discussion
PowerBI : MATRIX dynamic Row based on slicer selection
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
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.
2 Replies
- lbendlin
Super User
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
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.
