Forum Discussion

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago
Solved

Conditional formatting only applying to one rule

Hi There,   I have a % measure which changes according to the week the page is filtered on. I need to add conditional formatting to this measure in a table which compares the previous week with the...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Hayleysea , 

    I am not sure which cause your problem, I think you need to use Meausre(you siad that your measure name is Measure) in conditional formatting like below

    In addition, you aslo could add this measure in table to see the value of measure(check whether it will contains other number or it willl only return one value).

    You also need to check your expression, this seems to be duplicated condition.

    By the way, if possible, you also could upload your sample on forum, then we could check this in our environment.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

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

Hayleysea's avatar
Hayleysea
Icon for Resolver II rankResolver II
6 years ago

Okay thanks, It's in my original description 🙂 the measure i'm using behind the conditional formatting is:

 

Measure = IF(CALCULATE(([%]),DATEADD(Table[Date],-7, DAY))< [%], 1, IF(CALCULATE(([%]),DATEADD(Table[Date],-7, DAY))> [%],2, IF(CALCULATE(([%]),DATEADD(Table[Date],-7, DAY))< [%],3)))

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Yes, I got that. But please provide the DAX query for measure [%].