How do you conditional colour the maximum value in Bar chart?

[Anonymous]

Hello everyone.

How would I ensure the maximum value (in this case March) be coloured differently to the rest of the values? Thanks

[LivioLanzo · Accepted solution]

Hello @Anonymous

you need to create two measures:

MaxValue = 
VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] )
RETURN
IF( [Total Sales] = _MAXValue, _MAXValue, BLANK() )

and

SalesTotal = 
VAR _MAXValue = MAXX( ALL( 'Date'[Month], 'Date'[Month Number] ), [Total Sales] )
VAR _TotSales = [Total Sales]
RETURN
IF( _TotSales = _MAXValue, BLANK(), _TotSales )

where  [Total Sales] is this measure (this depends on your model and is the 1 your currently using in your chart above):

Total Sales = SUMX( Sales, Sales[Net Price] * Sales[Quantity] )

then add STACKED bar chart with months on the X axis and the two measures. Also for temporal data, i advise you to place it horizontally and not vertically

[Anonymous]

Worked great thanks