Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column chart visual data color conditional formatting not working when slicing the visual

I have a line and stakced column visual with availability % per asset. I have applied conditional formatting to the data colors and formatted by rules; with the rules being: If availability < 90% t...
Need Help
  • JosefPrakljacic's avatar
    JosefPrakljacic
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

JosefPrakljacic 

 

I've set up a DropBox but need your email address to share the file with you. Are you able to provide this?

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    JosefPrakljacic 

     

    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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        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