Forum Discussion
Power BI Matrix Visual Formatting
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.
Hi ponyo_pankun
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.
4 Replies
Hi ponyo_pankun
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"
Hi ponyo_pankun
Check this video for better understanding:
https://www.youtube.com/watch?v=OEe_SmQOa6Uhttps://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!
Thanks for helping. The solution from suparnababu8 meets my requirements.
