Forum Discussion
Measure Use in Custom Formatting
nabandla , In Power BI, conditional formatting based on field values requires the field to be a numeric value that can be evaluated directly. When you use a measure that returns a boolean value (TRUE/FALSE), it may not be directly usable in the conditional formatting settings because Power BI expects a numeric value for such operations.
For more details you can go through below article
bhanu_gautam- if i change the calcualtion from Boolean to 1 and 0 --> Selecting the Field Value still i am unable to populate that
Do i have to change the calculation in a way to use it ??
Hi nabandla ，
Thank you bhanu_gautam very much for the solution, and on the basis of what you've done, I'll suggest a little something that will further help him out:
When I also set it to 1, 0 it is also not recognized here, because it is possible that 1, 0 is also treated as a boolean value for some specific values, so I tried to do a substitution for 1, 0.
When we put double quotes around 1, 0, we can use field value, the
This specifies that 1 and 0 are used as integers.
It works, but it's pointless. If you want the same effect as rules, you can try defining the arrows manually.
If you have other needs for conditional formatting, this is the documentation I found for you, I hope it helps.
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi nabandla ,
Regarding our discussion, I wonder if this issue has been resolved by now? It's been a long time since I've heard back from you and I'm not sure if all is well. Please feel free to let me know if there is anything else I can do to help.
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
