Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting by Rules not updating

Hello! I've a column setup based on conditonal formatting by Rules. But it's not updating on adding new values to the table. In the snapshot below, I added 0.35 which should be green based on the co...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , The measures I see in visual and the measure I see in conditional formatting are different?

     

    can you check the value of the measure used in conditional formating (sum of a column)

  • T4S3R's avatar
    T4S3R
    4 years ago

    Hi Anonymous 

    if you take a look at the screenshot and compare the column name in the upper half of the screenshot (A_Steer Left) and the bottom half (A_Rear 1 Left) you will see that they are different. 

    Power BI basically calculates the result for the column A_Rear 1 Left for your conditional formatting and not for A_Steer Left. Thats what amitchandak meant.

    Please try to change the column you are using inside the conditional formatting from "A_Rear 1 Left" to "A_Steer Left" and see if that fixes things.

     

    Best regards

    Timo

T4S3R's avatar
T4S3R
Helper II
4 years ago

Hi Anonymous ,

 

two things I can think of with the info provided:

1. The value for the field you are doing the formatting on (A_Rear 1 Left) calculates something other than 0.35

2. The value 0.35 is a total of some sort and is not formatted due to your "values only" setting.

 

Best regards

Timo

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Timo, Just added randon values to avoid the Total case. Still no success 

     

    • T4S3R's avatar
      T4S3R
      Helper II
      4 years ago

      Hi Anonymous 

      if you take a look at the screenshot and compare the column name in the upper half of the screenshot (A_Steer Left) and the bottom half (A_Rear 1 Left) you will see that they are different. 

      Power BI basically calculates the result for the column A_Rear 1 Left for your conditional formatting and not for A_Steer Left. Thats what amitchandak meant.

      Please try to change the column you are using inside the conditional formatting from "A_Rear 1 Left" to "A_Steer Left" and see if that fixes things.

       

      Best regards

      Timo

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks, Timo! I corrected it
        Works perfectly now