Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I need to create the folloiwng matrix:
How can i create this formating when the header and left column are gray and the rest is white?
Thank you.
Solved! Go to Solution.
In the Format pane, expand Style and set Style to None. Then expand Column headers and set Background color to your gray color. Then expand Row headers and set Background colors to your gray color.
Hello @Roinka
You can set those options under the Column headers and Row headers formatting. You will also want to turn off Banded row style under Values
Thank you!
Please note that in my example it has black frame at the top and a black line at the bottom. How can i add those?
For the top, under column headers you can turn on the outline: bottom only. I don't think there is a way to add one to the bottom of the table undless you turn on the border for the whole table.
How do you change the outline color and the border color?
Outline color is under Grid and the border color us under border.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 21 | |
| 20 | |
| 14 |
| User | Count |
|---|---|
| 59 | |
| 53 | |
| 41 | |
| 31 | |
| 31 |