Forum Discussion

Helper I

2 years ago

Measure Use in Custom Formatting

HI @All, I have created table Visual with Sub-Category and Sales and Created a DAX Measure = IF(SUM(Sales)>=POWER(10,5),TRUE(),FALSE()) wanted to use this Measure in Conditional Formatti...

Helper I

2 years ago

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 ??

Anonymous

Not applicable

2 years ago

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 Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.