Forum Discussion

taylororiger's avatar
taylororiger
Icon for Helper II rankHelper II
4 years ago
Solved

Measure not able to apply to conditional formatting

I am trying to apply conditional formatting through a measure I created (worked correctly with a different data set), however when I go to apply the conditional formatting, it does not allow me to cl...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, taylororiger 

     

    I checked your code and found that you are missing a symbol which is causing the result to be wrong.

    You need to change  & to &&.  & is for concatenating strings.

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

taylororiger's avatar
taylororiger
Icon for Helper II rankHelper II
4 years ago

I do not want to complete the rules field as I want it apply to my measure?

 

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    4 years ago

    taylororiger can you share what is the condtion you want to apply and what is the output of your measure. You can change the color according to the output of your measure in the conditional formatting tab.

    • taylororiger's avatar
      taylororiger
      Icon for Helper II rankHelper II
      4 years ago

      This si the measure I am trying to apply conditional formating to in my table

      Can you visually show how to display this in the conditional formatting when selecting "Rules"?  I selected "Rules" and my table then could not be displayed.