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

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

    • dax's avatar
      dax
      Icon for Community Support rankCommunity Support
      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.