Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional Formatting in Matrix Visual

I have a matrix visual showing data of 4 months. Computers name in row field, dates of 4 months in Column field and CPU average of every computer in Value field. I want to change background colour of...
Need Help
  • AnkitaaMishra's avatar
    AnkitaaMishra
    2 years ago

    Hi Anonymous , 

    Thanks for sharing the dataset again. Using the dataset, the output is coming for FEB month as below : 

    For March: 

     

    Please follow the steps given below to get the above output : 

    • Please create a month column if it is not already present in the dataset :
    • Create below 2 measures (Max_CPU_Average and ConditionalFormatting1) and follow the steps given in previous reply to use the ConditionalFormatting1 measure to get the background color

       


       

      If this resolves your problem, please select it as the solution

     

    Thanks,

    Ankita

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi , 

I have followed the same steps but still it's not working.

AnkitaaMishra's avatar
AnkitaaMishra
Icon for Super User rankSuper User
2 years ago

Hi Anonymous , 

Thanks for sharing the dataset again. Using the dataset, the output is coming for FEB month as below : 

For March: 

 

Please follow the steps given below to get the above output : 

  • Please create a month column if it is not already present in the dataset :
  • Create below 2 measures (Max_CPU_Average and ConditionalFormatting1) and follow the steps given in previous reply to use the ConditionalFormatting1 measure to get the background color

     


     

    If this resolves your problem, please select it as the solution

 

Thanks,

Ankita