Forum Discussion
vimina
3 years agoFrequent Visitor
Condition format one measure based on another measure
Hi, I am wondering if there is any way to condition format one measure based on another. Attaching pbix file for reference: https://drive.google.com/file/d/1uPF5RgDhz9V9UTsmBI86pKyDcVuoONka/view?us...
- 3 years ago
I have found the solution using text box. I used two measure with switch statement to generate the value based on condition and formated the font color accordinly.
Note: the hidden icon will dissapear once published onlineReference: QT#75 - Add Conditional Formatting to Values INSIDE a Power BI TEXT BOX - YouTube
vimina
3 years agoFrequent Visitor
I have found the solution using text box. I used two measure with switch statement to generate the value based on condition and formated the font color accordinly.
Note: the hidden icon will dissapear once published online
Reference: QT#75 - Add Conditional Formatting to Values INSIDE a Power BI TEXT BOX - YouTube