Bar chart columns colour based on DATA

[dsmitha]

Hi,

In our dashboard we have a bar chart visual which is based on sales. Our main items are mobile handsets of a specific brand. Our brand has different colours of handsets,  we would like to show the  handsets sales based on their colors  in the bar chart , i.e. for red colour handsets  the bar should in red colour like that.

kindly advise how to make this happen

regards,

dsmitha

[PhilipTreacy · Accepted solution]

Hi @dsmitha 

Download example PBIX file

Create a conditional formatting rule for the bar chart like this

regards

Phil

[dsmitha]

HI PhilipTreacy,

Thank you very much, this is what i was looking for

double kudoz

regrads,

smitha