Forum Discussion
Solved
Conditional Formatting a Bar Chart using a measure
I am trying to simply add this conditional color to bar chart such that if it is more than average one color be used and if it is less than average another color. Take Red and Green. Here is the...
The soluton did not work exactly but were useful. I was able to resolve it in a differnet way. This can be closed.
Thanks cengiz for replying again. Correct me if I am wrong but sounds apart from the 1st and 2nd definition I have tried this. Yes, there is no category and I am doing for all the data.
Also if I do not add
SELECTEDVALUE in front of columns name in the measure definition, I get the error of
" A single value for **** can not be determined" which I am sure you are familiar with. Maybe in your case you won't need it.
Any thoght why it wokrs for Effects background but not for Bars?
That “single value cannot be determined” error is exactly why you should aggregate the column into measures.
Total Past Due =
SUM ( 'Summary'[Total Past Due] )
If Average_TotalPastDue is already a column with the same value repeated, still create a measure:
Average Past Due (overall) =
AVERAGE ( 'Summary'[Total Past Due] )