Forum Discussion

LillyLegenda's avatar
LillyLegenda
Icon for Helper III rankHelper III
3 years ago
Solved

Coloring Bar chart dynamically by value of x-axis

Hello, I would like to color the bars in my bar chart accoring to the year on the x-axis: The largest year (Max Year) should be red, second largest blue (Max Year -1) , third largest yellow (Max Yea...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    Try:

     

    Bar Colour =
VAR _YR =
    MAXX ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] )
VAR _YR1 =
    MAXX ( EXCEPT ( ALLSELECTED ( 'Date'[Year] ), { _YR } ), 'Date'[Year] )
VAR _YR2 =
    MAXX ( EXCEPT ( ALLSELECTED ( 'Date'[Year] ), { _YR, _YR1 } ), 'Date'[Year] )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Date'[Year] ),
        _YR, "Red",
        _YR1, "Blue",
        _YR2, "Yellow"
    )

     

     

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
3 years ago

Try:

 

Bar Colour =
VAR _YR =
    MAXX ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] )
VAR _YR1 =
    MAXX ( EXCEPT ( ALLSELECTED ( 'Date'[Year] ), { _YR } ), 'Date'[Year] )
VAR _YR2 =
    MAXX ( EXCEPT ( ALLSELECTED ( 'Date'[Year] ), { _YR, _YR1 } ), 'Date'[Year] )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Date'[Year] ),
        _YR, "Red",
        _YR1, "Blue",
        _YR2, "Yellow"
    )

 

 

 

  • LillyLegenda's avatar
    LillyLegenda
    Icon for Helper III rankHelper III
    3 years ago

    Amazing it is working! Thank you very much!