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

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

Hi Anonymous , 
If your expected output is as shown below where the max value is highlighted in the matrix : 


Then please follow below steps : 
 

  • create a measure with below DAX where Sheet1[Value] is your average of CPU column : 
  • go to format your visual ---> under Cell Elements ---> choose your series -->bacground color---> click on 'fx' function 
  • use the conditionalformatting measure created in step 1 as shown below : 


    If this resolves your issue, please select the reply as your solution.

 


 

 

  • 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

      Could you please share the error or DAX that you have implemented?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Please find the below DAX which we created based on your reference:

        Note: CPU AVG is a table name , CPU Avg is a column name

         

        Conditional Formating =
        Var Highest = CALCULATE(MAX('CPU AVG'[CPU Avg]),ALLSELECTED('CPU AVG'))
        Var measurecolumn = SELECTEDVALUE('CPU AVG'[CPU Avg])
        RETURN
        IF(measurecolumn=Highest,"#EE0B51","FFFFFF")
    • 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