Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Coloring values depend on column header

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.

Tips and Tricks

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

       

       

      • KeyurPatel14's avatar
        KeyurPatel14
        Responsive Resident
        3 years ago

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

  • KeyurPatel14's avatar
    KeyurPatel14
    Responsive Resident
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you KeyurPatel14 

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