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.

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

Hello Hayleysea,

I tried on measure too. And for me, it is working as expected. Please see below:

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

Thankyou! Could you please share your measure? I think that's where my problem is.

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

    Hayleysea, I have used my measure. Can you please share your measure so that I can see where the problem is?

    • 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 [%].