Forum Discussion
Alternating colours for BAR Graph with single measure without any conditional formatting
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
Super Usersuyogbi , 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
amitchandak how can we achieve this with conditional format? i just need to show alternating colour bars. i dont have any specific condition.
- amitchandak
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
amitchandak Thank you so much. this solves my requirement.😊 cheers.. 👍
