Forum Discussion
Helper IIMeasure 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 click the measure, as shown below;
Any thoughts?
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
6 Replies
- negi007
Community Champion
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)
taylororigerI 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
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
Community Support
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
