Forum Discussion

suyogbi's avatar
suyogbi
Frequent Visitor
5 years ago
Solved

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 ...
  • Fowmy's avatar
    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])
    )