How to pass max of slicer selected date to filter the data for a chart

[divyakolavil]

Hi All,

I have a table named CY, which has date-wise inventory at Brand/Division level. (below)

I have another SOH_Calendar table having the list of dates for which inventory is available., and i have kept a slicer from this table

and below formula returns the max of selected dates

Now as you see the first barchart shows week on week inventory.

Rest of the charts should show the Inventory by Brand/BU  and Division for the max date selected in the slicer.

Currently it shows the summ of inventory of all the selected dates.

Is there a way i can pass the max selected date to these charts?

Thanks in advance

[divyakolavil]

Wow @fahadqadir3 , it worked like charm 🙂 Thank you for your quick support

[fahadqadir3 · Accepted solution]

@divyakolavil review the attached screen shot, for Donut chart data only latest date  selected in slicer appears.

You need to add filter for chart, select Top N as Filter 

Select ‘Top’ and input ‘1’. This tells the filter to choose only the highest or lowest single value.

For ‘By value,’ drag over the date field from the Data Pane and change to ‘Latest.’

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!