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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
LuciferMstar
Helper I
Helper I

Hide/Show matrix, or rows in matrix based on conditional filter

Hello Power BI Community,

 

I need your help with this one. I have a report with some visuals that are filtered by a condition where a user should/sloudn't see the results based by the number of people in their team who completed a survey. Now, this filter works on any other visual, except on a matrix. The user is able to read the matrix rows even though the other visuals values are not shown. That matrix contains the comments of the people that have responded to that survey and the comment is shown by expanding [+] two rows. So I can't really do the magic trick to hide the whole matrix with another visual on top because the users for whom the filter doesn't apply still need to expand the rows.

 

I've run out of the ideas on how to approach this. 

 

Thanks!

2 REPLIES 2
v-janeyg-msft
Community Support
Community Support

Hi, @LuciferMstar 

 

I really want to help you, but it is difficult to reproduce your scene with only text description.

Can you share some sample data and your desired result?So we can help you soon,thanks.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards

Janey Guo

 

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

amitchandak
Super User
Super User

@LuciferMstar , Not very clear.

But these type of things can work with a bookmark with button

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

or conditional drill through

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.