Measure not able to apply to conditional formatting

[taylororiger]

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 click the measure, as shown below;

Any thoughts?

[taylororiger]

Is there a way to change my measure data type to text?  Would this make it able to apply as a field value?  It is ont an option in the drop dow of data types.

[v-janeyg-msft · Accepted solution]

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

[negi007]

@taylororiger select rules from the drop down instead of field value

links for help

Power BI Conditional Formatting (Step by Step Guide with Examples) (wallstreetmojo.com)

How to Do Conditional Formatting In Power BI with Rules - Font Color Scales (gigxp.com)

[taylororiger]

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

[negi007]

@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]

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.