Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.?
thank you for responding but that did not work.
Use conditional formatting and paint the second level headers as white text on white background.
What would the expected result look like?
Below is how I expect theresult to look like
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 17 | |
| 11 | |
| 10 |