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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.