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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
jums
Frequent Visitor

hide 2nd row header but show its values

I have a matrix showing sales person(row header 1 ) and their respective divisions (row header 2) and the profit (value) they made per product(column). is there any way in powerbi that I can hide the division which is the second row header but still have the profit broken down as shown in the matrix.?bi.PNG

 

 

 

5 REPLIES 5
YalanWu_test
Helper I
Helper I

Hi, @jums ;

You could set as follow:

YalanWu_test_0-1660099128279.pngYalanWu_test_1-1660099141961.png

Then pull it to hide column.

YalanWu_test_2-1660099223448.png

The final show:

YalanWu_test_3-1660099265717.png

Best Regards,

thank you for responding but that did not work.

Use conditional formatting and paint the second level headers as white text on white background.

lbendlin
Super User
Super User

What would the expected result look like?

jums
Frequent Visitor

 

Below is how I expect theresult to look like

 

Capture.PNG9.PNG

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 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.