different color on every bar of column chart

[Anonymous]

Hi, Morning!

Like the title, could PBI have some methods to achieve the founction?  

Difference color on every bar of column chart , which the chart with one dimension / series but multiple values, you konw since on value one bar and one color...

If yes, could you share a short sample out? 

tks!

[amitchandak · Accepted solution]

@Anonymous , You use conditional formatting and colo divergence. Or you set other values.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Or you can create a color measure based on values of your dimension and use that  after choosing "field" in color formatting

Like these

Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))

Color = if(FIRSTNONBLANK('Date'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column