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
amitchandak how can we achieve this with conditional format? i just need to show alternating colour bars. i dont have any specific condition.
Super Usersuyogbi , 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.. 👍
amitchandak how to handle the ties here? ties are giving same color in graph.
both skip and dense not helping ..