Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |