Alternating colours for BAR Graph with single measure without any conditional formatting

[suyogbi]

Hi All,

I have a requirement where i need to show alternating colour in bar graph which has only single measure (salesamount) in Values and the AXIS(Customer) around 5000 Customer. there is no condional formatting requirement, just need to show 2 diff colours in alternating format.

any work around for this?

Thanks in Advance.

Suyog

[amitchandak]

@suyogbi , No, you have to use conditional formatting to get this.

May be create a rank on customer and measure and use mod with 2 and us that in conditional formatting

[suyogbi]

@amitchandak how can we achieve this with conditional format?  i just need to show alternating colour bars. i dont have any specific condition. 

[amitchandak · Accepted solution]

@suyogbi , Try like  

sales amount

Rank = rankx(allselected(Table[Customer]), [sales amount])

// sales amount is a measure  

Color = 

var _1 = mod([Rank],2) 

return 

if(_1,=1, "Blue", "Green")

You need use conditional formatting using field value option with this measure 

[suyogbi]

@amitchandak  how to handle the ties here? ties are giving same color in graph.

both skip and dense not helping .. 

[suyogbi]

@amitchandak  Thank you so much. this solves my requirement.😊 cheers.. 👍