Forum Discussion

badger123's avatar
badger123
Resolver I
7 years ago

Highlight max value in column chart

Hi all,   I'm trying to figure out how to highlight the max value in my simple column chart. E.g. here I would like Feb 2019 bar to be a different colour from the rest. Please can someone help?   ...
Tips and Tricks
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi badger123,

 

The second one should work. Please refer to my test and the snapshot.

Measure =
VAR maxSales =
    MAXX ( ALLSELECTED ( 'Calendar'[Short_Date] ), [Sum_Values] )
RETURN
    IF ( [Sum_Values] = maxSales, [Sum_Values], BLANK () )

Highlight-max-value-in-column-chart

 

 

Best Regards,

  • badger123's avatar
    badger123
    Resolver I
    7 years ago

    Thanks v-jiascu-msft for this. I tried following the steps but for some reason it's not working as expected. Do you know why this is? Is it because my Short_Date is text not date? When I use an actual date column it works. Is there a way I can format date MMM-YYYY?

     

    • SJim's avatar
      SJim
      Frequent Visitor
      7 years ago

      MMM-YYYY default option is not possible but MMMM yyyy is:

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi SJim ,

         

        Could you please mark the proper answers as solutions?

         

         

        Best Regards,

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi badger123,

       

      The Short_Date in such a format is surely a Text. It should be from an independent date table. I guess yours is from the fact table which contains the Values column. Isn't it? If so, I would suggest you create a new date table and establish relationships.

       

       

      Best Regards,