Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional formatting not working for Last Month in matrix table

Hi there 

 

Hope someone can help we with this. 

 

I have created a matrix table showing results for Current Month and Last Month. 

As you can see, the green (or positive results) for LM isn't showing up. Orange and Red are.

CM is showing up fine. 

 

Here's the DAX for one of the LM Conditional Rule 

I have used this for condition formatting. 

 

I can't figure out why the positive (green) results aren't showing up. 

Hope there's someone able to assist. 

 

Thank you

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Ok I figured out the issue. 

    It was a small oversight causing so much headache. In the Conditional formatting the value was set to "Percent" as opposed to "Number". 

    Thought I'd post this here anyway instead of deleting the topic, in case anyone else face the same issue. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Ok I figured out the issue. 

    It was a small oversight causing so much headache. In the Conditional formatting the value was set to "Percent" as opposed to "Number". 

    Thought I'd post this here anyway instead of deleting the topic, in case anyone else face the same issue.