Forum Discussion

badger123's avatar
badger123
Icon for Resolver I rankResolver 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
badger123's avatar
badger123
Icon for Resolver I rankResolver 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?

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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,