Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Conditional formatting in table and card

Dear community, Please help me with below-mentioned problem statement to change the background color of a cell if it is negative Data Sample ( A table) Target Actual Deviation 100 ...

Tips and Tricks

amitchandak
6 years ago
Anonymous , You either use rule-based conditional formating or create a color measure and use that with "field" option

example

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

Super User

6 years ago

Anonymous , You either use rule-based conditional formating or create a color measure and use that with "field" option

example

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692