Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
swasim
Helper I
Helper I

Matrix with drill down : Display certain rows 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 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.

swasim_0-1728054378872.png

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

 

3 REPLIES 3
Anonymous
Not applicable

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
Super User
Super User

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

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.