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 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
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
- Hi Josef,I've come up with the measure:Availability Colour = IF(( (SUM(EquipmentDetails[Scheduled_Hours]) - SUM(DailyDowntime[DailyDownTimeHrs]) )/ SUM(EquipmentDetails[Scheduled_Hours]) )>= AVERAGE(TargetKPIs[Availability_pct]), "01B8AA", "#FD625E")And then format the color based on "field value" of this measure.The only problem is that I'm using the Average of the Target Availability and not individual values for each equipment. This becomes an issue if I filter the charts to include two or more different models/assets that do not have the same availability target.Can you think of a solution?Regards,Brandon
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