Forum Discussion
Column chart visual data color conditional formatting not working when slicing the visual
Anonymous It seems that we have a bug here or the percentage is calculated in a way I don't understand.
For the others what have I done - I changed the formatting rules and used numbers instead of percentages (0, 0.9, 1).
It worked then...
BR,
Josef
Anonymous
Many don't manage to provide sample data, so I thank you for that :smileyvery-happy:
I have built up a sample file, but I have the problem that the relationships don't seem to work properly.
I also believe that your relationships are the cause of the misbehaviour. (For example, is the filter direction properly defined in your model?)
So to get to the bottom of these errors, I need the Power BI file from you.
In this forum the file must be available as Link to an Ondrive/Google Drive whatever.
BR,
Josef
I've set up a DropBox but need your email address to share the file with you. Are you able to provide this?
Anonymous It seems that we have a bug here or the percentage is calculated in a way I don't understand.
For the others what have I done - I changed the formatting rules and used numbers instead of percentages (0, 0.9, 1).
It worked then...
BR,
Josef
Legend!
Such a simple fix... the data type for the measure was % and still is % when it works, but as you said, it only seems to color format correctly with the rule based on number rather than %.
Thanks for your help.
Now that we have the color conditional formatting working based on a fixed value, is it possible to use a variable instead? Namely, the Avialability and MTBF KPI targets?
Ideal result would be to have the column chart be green if it is above these variable targets and red if it is below the target.
Regards,
Brandon
I think it is possible. You write a measure which is generating the color.
May I refer you to this awesome posthttps://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
BR,
Josef