Grouping / Coloring Level 2 Row Headers of Matrix Table

[Anonymous]

Hi, I am trying to color the Row Headers of a Matrix table:

For the column Customer, I would like to give it a color, based on its grouping. Let's say we have customer ABC123, in the table its value under the Group column is 'Blue', for every item of this Customer.

Would it be possible to match the cell value to this Group. I would also like to sort by these groups, so it goes Sector > Group > Customer, alphabetically.

[AnalyticPulse]

yeah its possible. add calculated column in table to assign a values to your grouping. then go to conditional formating inn format pane in powerbi and chose the feilds option and then configure the colour conditions based on your choice. like, when feild value is = 1 then green otherwise blue etc. 

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/

See my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/

[Anonymous]

Do you have any screenshots of which function I should use in visualization? Currently, I only seem to have the option to edit the cell values...

[Anonymous]

Hi @Anonymous ,

I think you can use conditional formating in Matrix. Here is a simple example.

Firstly I create a new measure.

Measure =
IF ( SUM ( 'Table'[Sales] ) > 100, "Red", "Green" )

Then I go to the conditional formating and choose Background color.

Next we can choose the Measure we created.

Finally you will get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 

Thank you for your description and screenshots. Only this applies to the values, not to the secondary row headers, which is what I want:

At this point, I'm not sure this is at all possible in Power BI?

[Anonymous]

Hi @Anonymous ,

If you want to change the background color of the row headings and column headings, you can't currently do that in Power BI, you can only change the background color of the Value.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

That's unfortunate, thank you for all your input!

[Anonymous]

Hi @Anonymous ,

I need to change what I said above, I have always understood that changing the background color of row and column headers is done dynamically, but if it is done statically I think it is possible.

You can change the background color in Column headers and Row headers in the matrix view.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for thinking along. However, this doesn't solve my issue, due to two reasons:

1. I do need it to be colored dynamically, as I want customers of group 'Green', 'Blue', etc. to show the corresponding color, and this varies per customer.

2. As I see it, this can only be done for the main row header. So I was able to change the color of the 'Sector' column (again, statically, so all the same), but not for the second level 'Customer' column, which is the one I need to change.

If someone knows a solution for this, I would love to hear it. Currently I feel like I will just have to wait for another Power BI update that allows for this...