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
Hallo Anonymous,
so is it allowed to filter the availability with certain values or not - depending on your answer it would be either a heavy usage of hasonefilter or allselected.
May I ask you to explain it a bit more with examples
BR,
Josef
An example might be the Availability Target for the equipment under model 793F may have a different Availability Target (for example 90%) than the equipment under model 830E-AC (for example 80%). Therefore, if I show both of these models in the chart at the same time, the color conditioning formatting will work on the average of their avaialbility (for example, if there is the same number of equipment for each model then the average Availability Target is 85% and so the color conditioning formatting will make the bars green if they're above 85% and red if they're below this). Instead, I'm trying to find a way to make the bars green if they're above 90% for the 793F equipment and green if they're above 85% for the 830E-AC equipment.
Regards,
Brandon