Forum Discussion
suyogbi
5 years agoFrequent Visitor
Alternating colours for BAR Graph with single measure
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. i created ...
- 5 years ago
suyogbi
Since you have ties in your ranking, the Rank calculation has to break it first. I created the following ranking measure and used it in your CF measure. The file is attached below my signature.Rank = VAR __customernamerank = ADDCOLUMNS ( ALLSELECTED ( Customers[Customer Name] ), "RankCust", RANKX ( ALLSELECTED ( Customers[Customer Name]), CALCULATE ( MAX ( Customers[Customer Name] ) ) ) ) VAR __maxcust = MAXX ( __customernamerank, [RankCust] ) VAR __customerrank = ADDCOLUMNS ( __customernamerank, "Rank", RANKX ( __customernamerank, [Sales Amount] * __maxcust + [RankCust] ) ) RETURN IF( HASONEVALUE(Customers[Customer Name]), MAXX(FILTER(__customerrank,Customers[Customer Name] = MAX(Customers[Customer Name])),[Rank]) )
Fowmy
Super User
5 years agosuyogbi
Since you have ties in your ranking, the Rank calculation has to break it first. I created the following ranking measure and used it in your CF measure. The file is attached below my signature.
Rank =
VAR __customernamerank =
ADDCOLUMNS (
ALLSELECTED ( Customers[Customer Name] ),
"RankCust",
RANKX (
ALLSELECTED ( Customers[Customer Name]),
CALCULATE ( MAX ( Customers[Customer Name] ) )
)
)
VAR __maxcust =
MAXX ( __customernamerank, [RankCust] )
VAR __customerrank =
ADDCOLUMNS (
__customernamerank,
"Rank",
RANKX ( __customernamerank, [Sales Amount] * __maxcust + [RankCust] )
)
RETURN
IF(
HASONEVALUE(Customers[Customer Name]),
MAXX(FILTER(__customerrank,Customers[Customer Name] = MAX(Customers[Customer Name])),[Rank])
)