Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hi,
i have been trying to color my (line & clustered column) chart with conditional formatting based on the following settings:
where i wish to have green color for +ve valued columns & peach color for -ve valued columns.
somehow it works for some charts but not working for others where the supposedly -ve valued columns are still in green (when they should be in peach color). here's a typical problematic chart showing -ve valued columns are in green color:
when i reviewed the setting, it seems that it's perpetually changed as follows despite changing them repeatedly to setting as per the 1st graphics:
i'd appreciate if someone can assist to advise how to resolve this.
tks & krgds, -nik
Solved! Go to Solution.
I've had the same problem couple weeks ago. When i copied a visual and edited it it did not work, but when i remade the visual from scratch the logic did work.
Hope this helps you out.
Quality over Quantity
Hi @Anonymous
i think such behaviour is a consiquence of grey words "minimum" and "maximum" usage in first screenshots
It is the only hints, not exactly minimum and maximum values. You should point exact values in conditions
Also, "percent" is default unit for conditional formatting.
tks for your response too, @az38.
can you kindly advise what exact values should i put in there instead to get red as i have tried it (using '0') without success many times earlier?
krgds, -nik
I've had the same problem couple weeks ago. When i copied a visual and edited it it did not work, but when i remade the visual from scratch the logic did work.
Hope this helps you out.
Quality over Quantity
yep... i redo the whole chart fm scratch & got it right.
anyway, it's probably a bug in the format painter that needs to be mended as it (format painter) is a very useful item if you need to redo the same formatting for many other charts efficiently.
many tks.
krgds, -nik
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |