Coloring values depend on column header

[Anonymous]

Hello community!

I have created a matrix and I want to color the values according to column header values of the [Securtiy Status] : "High" = red, "secure" = green, etc.

But I couldn't do it. Is it possible ? If yes can you tell me how please ?

Here is an exemple of what i want done with Excel

Thanks in advance.

[KeyurPatel14]

Hi @Anonymous ,
Okay let me tell you how you can achive this.

1.Select your matrix visual

2.Go to formatting pane

3.Go to visual section

4.Go to specific column

5.Select the measures or column you have plotted one by one under the Series dropdown (High,Low,Medium,Pending,Secure)

6.Go to values section and select the background color according to your requirement.
That's it. I Hope this will solve your problem.
If this helps then please give it a kudos and accept this as a solution.

Please refer the below image if you face any difficulties in finding the Specific column property.

6.

[Anonymous]

Thank you @KeyurPatel14 

but the problem I don't have (High,Low,Medium,Pending,Secure) as options and I don't why

[KeyurPatel14]

Can you please provide sample data ?

[Anonymous]

I am not sure that I understood what type of data you want but the numbers is the countDistinct(Device) in each county.

[KeyurPatel14]

You have to create measures for all the status and then add those measures in Values section of your matrix.
Please try this and let me know.

[Anonymous]

but I want the [Securty Status] as columns not values 

[KeyurPatel14]

Please refer the above post made by me.
I have Implemented the same on my data and it is working perfectly.