Forum Discussion

PS_78's avatar
PS_78
Helper II
2 years ago
Solved

Conditional Formatting Issue

Hello - I am having an issue with conditional formatting as detailed below. Please let me know where I am going wrong.   As you can see from the table below, I have tried with both column and measu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PS_78 ,

    I've noticed that when you introduce an indicator with a value of “May” it causes the other indicators to be colored, even if they don't have a value. So when “May” is introduced, it recalculates the formatting in the dataset. So first I think you might consider adding placeholder values (e.g., 0 or null) for “May” in other indicators to keep the formatting consistent.

    Secondly I think you can re-edit your Measure, try using the SWITCH(), IF() functions.

    Measure = IF(MAX('Table'[Total]) > 50,"Green", "Red")

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PS_78 ,

I've noticed that when you introduce an indicator with a value of “May” it causes the other indicators to be colored, even if they don't have a value. So when “May” is introduced, it recalculates the formatting in the dataset. So first I think you might consider adding placeholder values (e.g., 0 or null) for “May” in other indicators to keep the formatting consistent.

Secondly I think you can re-edit your Measure, try using the SWITCH(), IF() functions.

Measure = IF(MAX('Table'[Total]) > 50,"Green", "Red")

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PS_78's avatar
PS_78
Helper II
2 years ago

Hello Anonymous  - Thanks for the response. Can you please let me know how we can add a placeholder values?

 

Thanks,

Phani