Forum Discussion
Conditional formatting
Hello, I have a measure that I need to have conditional formatting applied on. But for some reason It does not respond to the formatting. Does anyone have any idea of the reason, and how the formatting can be applied?
Measure deliv = CALCULATE(SUMX('Delivery Q2';'TS Delivery Q2'[On Time])/sum('Delivery Q2'[Total # of order lines]))*100Calc-value = IF(ISBLANK([Measure deliv]);0;
IF(0,2*[Measure deliv]-16<0;0;
IF('Delivery Q2'[Measure deliv]<85;0,2*[Measure deliv]-16;
IF([Measure deliv]<96;0,1818*[Measure deliv]-14,445;
IF([Measure deliv]-93>5;5;[Measure deliv]-93)
)
)
)
)Calc value will return values between 0-5 and is the measure that i want to apply formatting to.
Hi tex628,
Based on my test, the returned value of [Calc-value] is changed dynamically depend on the actual value of [Measure deliv].
What do you mean " but the formatting doesn't work."? Please describe your scenario with sample data. Also, please show us what the correct result should be and what the incorrect result you have got.
Regards,
Yuliana Gu
6 Replies
When you say that it doesn't respond to formatting, are you saying that you don't get the option or that when you configure the formatting that it doesn't work?
I get the option, but the formatting doesn't work.
Which version of Power BI are you on? I just did this for a measure defined as below on the June 2018 version and it worked perfectly:
DiconnectedTableTrick = VAR __myVariable = SWITCH( MAX([Category]), "0-50 percent",1, "51-75 percent",2, "75-100 percent",3 ) RETURN __myVariable
Hi tex628,
Based on my test, the returned value of [Calc-value] is changed dynamically depend on the actual value of [Measure deliv].
What do you mean " but the formatting doesn't work."? Please describe your scenario with sample data. Also, please show us what the correct result should be and what the incorrect result you have got.
Regards,
Yuliana Gu
What i meant was that the conditional formatting did not work. But i solved the issue, in my table i had a value incorrectly displayed as "First value" by removing the summarization the formatting started working :)
/ J
