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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 67 | |
| 51 | |
| 46 | |
| 41 | |
| 39 |