Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am going through the matrix visual format settings on Matrix visual format settings - Power BI | Microsoft Learn, and I want to format my matrix visual the same as the screenshot that the documenation shows. The screenshot can be seen by going to the link provided or see it below.
Basically, I want to give the parent level the same background color, then give the children a different background color to indicate the grouping/hierarchy.
I can't seem to format it the same way as Microsoft did in their screenshot. In the screenshot, the parent level has a light grayish background color for each row, then the children have a white background color.
Solved! Go to Solution.
I understood your requirement. I hope you are looking for below kind of results.
If you want to achieve this you follow below steps.
There is option in Matrix chart formatting settings..Row-subtotals..In that you have backgorund color option, then turn on Apply to lables option. Pls refere to the below image,
I hope this works for you. Thank you for asking this.
Check this video for better understanding:
https://www.youtube.com/watch?v=OEe_SmQOa6U
https://www.youtube.com/watch?v=DmLozWHekMA&t=578s
https://www.youtube.com/watch?v=qphVQdI5rQs
above video would guide you from basic to advanced setting using different option under Matrix setting.
I hope above videos would help you to resolved your query!
Or you can simply check this setting of row subtotal:
I hope this might help!
I understood your requirement. I hope you are looking for below kind of results.
If you want to achieve this you follow below steps.
There is option in Matrix chart formatting settings..Row-subtotals..In that you have backgorund color option, then turn on Apply to lables option. Pls refere to the below image,
I hope this works for you. Thank you for asking this.
Thank you! Spent hours to format, and apparently, I was not able to spot "Apply to Labels"
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
73 | |
56 | |
38 | |
31 |
User | Count |
---|---|
83 | |
64 | |
63 | |
49 | |
45 |