Forum Discussion
Conditional Formatting based on calculated column inc + and - returned results
Anonymous
You can write a measure that you will use just to format your text.
Format Measure = MAX ( 'Table'[Diff] )
Then in the conditional formatting you apply the rules to that field.
Hi Anonymous ,
Please refer to the similar case: https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-percentage-of-multiple-values/m-p/720970#M347921
Best regards,
Dina Ye
Thank v-diye-msft , I will look at that thread to get an idea about what I'm doing wrong although jdbuchanan71 had me soooo close to solving this thing.
I know it's going to be something super simple too get this rectified but it's eluding me at the moment.
Would you happen to know why the measure isn't selectable in the conditional formatting pane?
Thank you
Hi Anonymous ,
It's unselectable in my side either, he should prabably add the calculated column rather than measure. that I'd like to suggest you add the format measure and then applied it to values measure. and the formula won't be very complicated. you can refer to the second part of my solved cases above.
Best regards,
Dina Ye
Hi Anonymous ,
It seems i happen to know the point, what's the data type of your measure? it does work when I use whole number, but failed to use non-number type.
Best regards,
Dina Ye
You two are the best!!!!
Thank you so much!
This is now solved so I will mark as complete.