Forum Discussion
Alternating colours for BAR Graph with single measure without any conditional formatting
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 co...
Anonymous , 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
Super User
Super UserAnonymous , 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 to handle the ties here? ties are giving same color in graph.
both skip and dense not helping ..