Conditional colour formatting on legend in a visual

[mtomova]

Hi all,

I have a clustered bar chart visual which tracks inspections for products.

To this visual I have added a legend which shows if the inspection is a 'pass' or a 'fail'.

How can I set the colors for the legend, so that if the inpsection is a 'pass', the bar color will be green, and for a 'fail' - red?

When I go to 'Format your visual' --> 'Bars', I see only 'All' in the 'Categories' drop down. I have set the colour to be green,

however, as soon as I add the legend, the colour of the visual changes to red.

If I remove the legend, then I can choose any color for the bar.

I have tested the visual with dummy data, where I have more than one record in the table, and when this is the case I can set the bar colors when I go to 'Format your visual' --> 'Bars'.

So, to me it seems that this strange behaviour is related to the fact that there is only 1 row of data in my current table I am using for this visual.

Thanks,

Maria

[mtomova · Accepted solution]

Hi all, 

at the end none of the proposed solutions worked and I couldn't find a fix.

The workaround I found was to copy a colour formatted donut chart, then changed the visual type

[Anonymous]

Hi @mtomova ,

Based on the testing, try to select pass and fail separately and set the colors individually.

The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@mtomova Once you add the legend, you need to go back and set your column colors again. 

[mtomova]

Hi, it doesn't work. I have tried that and changed different colors, but the red remains..

Thanks,

Maria