Forum Discussion
DAX conditional formatting on a switch metric measure
Hello,
Thanks in advance for your support!
I have written a dax measure (called as Master Measure) which returns formatted values using SWITCH:
On this measure I want conditional formatting on few statements in switch, not all. Formatting - red color for negative, green color for positive. Example DAX as shown below, I want color on SELECTEDVALUE(SALES_KPI_TRACKER[ORDER])=7 :
However, I am not able to achieve the desired formatting. An error in specifying positive / negative value is occurring i.e. in the part : [Master_Measure]>0. I tried removing FORMAT in first main dax, however, still not working.
Request your help on the same. Thanks
Change the Format setting of your Master Measure to be dynamic and copy the switch statement into the Format String Expression. Have the switch statement in the measure just return the value without any formatting, and you should then be able to use conditional formatting as normal.
Dr_BB - Both FORMAT and FIXED return a string value (text) which will be why you're unable to use an interger or decimal based rule.
You should make use of Dynamic Formatting for your measure, rather than the measure returning a string value.
https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/
If this helps, please consider marking it as the solution, it helps with visibility for others with the same challenge.
4 Replies
johnt75Super User
Change the Format setting of your Master Measure to be dynamic and copy the switch statement into the Format String Expression. Have the switch statement in the measure just return the value without any formatting, and you should then be able to use conditional formatting as normal.
- mark_endicott
Dr_BB - Both FORMAT and FIXED return a string value (text) which will be why you're unable to use an interger or decimal based rule.
You should make use of Dynamic Formatting for your measure, rather than the measure returning a string value.
https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/
If this helps, please consider marking it as the solution, it helps with visibility for others with the same challenge.
- lbendlin
You cannot measure a measure. Implement your conditional formatting rules in a separate parallel measure.
Hi Dr_BB ,
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
