Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have tried to use the new conditional formatting on rows feature however it is not working as i would expect. I would like all values and total in the column to appear as follows: negative as red, black as positive. I can only apply to values and totals using format by 'Colour Scale' so i have set the following:
however the result i get is all values including the positive are showing red, when i would expect positive values to have the default 'don't format' to apply which i would expect, display them black.
Solved! Go to Solution.
@julian999 , This is rule Based? I think you should try rule bases in this case.
refer Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
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
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
@julian999 , This is rule Based? I think you should try rule bases in this case.
refer Color Field - Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
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
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
OK. I deleted the old rule and created a new rule for the settings to apply.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |