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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
cevara89
Frequent Visitor

How to hide certain rows in a matrix table

Hi, 

I have a table with three rows from which I have to hide first two(Inbox and review).
Yellow color should stay on report, and red should hide from it.

Thanks in advance for any help.prtScr.png

4 REPLIES 4
lbendlin
Super User
Super User

Where are you stuck when you use your filters?

When I use my filters values 1000 and 700 are gone, but I need to have them in Total(=2000). Hired should be percantage of Grand total(sum of Inbox, review and hired).

You could make the row heights of the first two rows tiny, or render them in white font.

 

In general you do not want to confuse your users with inconsistent visuals.

Thank you for your reply.

I rendered them in white font, and it did the job, but it's not such nice solution, because I have two empty rows in table.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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