Forum Discussion

OEade's avatar
OEade
Frequent Visitor
4 years ago
Solved

Conditional Formatting locked to 'Percent' levels

Hi,   I'm looking to add conditionally formatted Icon bars to a Matrix, these need to be formatted based on Number rather than percentages. (A simple if this number is positive = green icon, negati...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, OEade 

     

    Maybe you can try the following.

    Measure:

    Measure = DIVIDE(SUM('Table'[Value1]),SUM('Table'[Value2]))
    Color = IF([Measure]>=0,"Green","Red")

    Does this match the output you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

     

     

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

Very strange, I am not able to replicate that behaviour.  Can you try clearing the conditional formatting from the table then adding it back in?

OEade's avatar
OEade
Frequent Visitor
4 years ago

I have tried this already unfortunately, even when recreating a new table I'm still faced with the issue.