Highlighting the max value in bar chart issue

Hi:

You can create a slicer where you choose how long the period under scrutiny will be

New Table :

Period = GENERATESERIES(1, 180, 3)

It will look like this:

Then you just sub in your table and measure names instead of mine: Your fact table with a date field replaces my 

 Retailer_Sales[Ship_Date]. And you use your [Avg Calls per Interval] measure where I used [Last x Days Sales].

 

It's important to have date table, marked as date table and formed relationship with your interval table. The result can look like(see last image).

 

Max Last x Days =

var periodselected = Period[Period Value]

var maxsales =

MAXX(ALLSELECTED(Retailer_Sales[Ship_Date]),

[Last x Days Sales])

var maxdate =

CALCULATE(MAX(Retailer_Sales[Ship_Date]),

FILTER(ALLSELECTED(Retailer_Sales[Ship_Date]),

[Last x Days Sales] = maxsales))

var final =

CALCULATE(SUM(Retailer_Sales[Qty_Sold]),

FILTER(Retailer_Sales,

Retailer_Sales[Ship_Date] > maxdate - periodselected &&

Retailer_Sales[Ship_Date] <= maxdate))

return

final

 I hope this helps! Below shows a mi value which just used min vs max in the same forumla. Good luck!

 

Hi bassmaninaus_PB ,

Please create this measure and set it to the bar chart conditional format.

Max Interval = 
VAR MaxInterval = MAXX(ALLSELECTED(Interval),[Avg Calls per Interval])
Return
IF(
   [Avg Calls per Interval] = MaxInterval,
    "Red"
)

Attached PBIX file for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data