Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 89 11
89 93 -4 ( change background color of the cell to red as it is negative)
92 88 4
78 88 -10
Case 1: where only deviation cell background should be red.
Case 2: Where I would like to show the background of entire row as red.
Another problem
Lets say I am calculating a measure through a formula and I would like to make its background as red if the calculated value is negative.
Please help me.
Thanks in advance
Solved! Go to Solution.
@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
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |