CODEWITHSUNDEEP
powerbiconditional-formattingcalculated-field
courty340
courty340

Reputation: 131

Why is my conditional formatting not working properly in PowerBI?

I am trying to add conditional formatting into my table and although it works for some of the data, about half of it is not returning any value for the condition.

    Condition = MAXX('2020 PNRs', 
   IF('2020 PNRs'[2020-2021] <=1, 1,
        IF('2020 PNRs'[2020-2021] <=10000 , 2,
            IF('2020 PNRs'[2020-2021] >10000 , 3))))

2020-2021 is a calculated measure

2020-2021 = 
SUM('TTV'[2020TTV]) + SUM('TTV'[2021TTV])

but it is quite simple so I am not sure if that has anything to do with why it's not working?

Here you can see where it works for some and not others

Upvotes: 0

Views: 1683

Answers (1)

Justyna MK
Justyna MK

Reputation: 3563

Your Condition formula filters '2020 PNRs' table. It might be that the top part of your screenshot presents results that are not available on '2020 PNRs', but are rather sourced from some other table (e.g. '2021 PNRs'?). It would be good for us to understand the source of your table and your data model.

In the meantime, I suggest testing the following measure:

Condition =
    SWITCH(
        TRUE(),
        [2020-2021], 1,
        [2020-2021] <=10000, 2,
        [2020-2021] >10000, 3
    )

If this still doesn't work, then return the value of [2020-2021] measure as the last argument to understand the issue:

Condition =
    SWITCH(
        TRUE(),
        [2020-2021], 1,
        [2020-2021] <=10000, 2,
        [2020-2021] >10000, 3,
        [2020-2021]
    )

Upvotes: 1

Related Questions