Filter values on slicer

[sandip]

Hi,

I have Category and Date column and I have used Category column in slicer and I want that when the report will load the category values will load based on Maximum date column. Can it be possible?

[EVEAdmin]

Do you think you can use a filter on the date column, where the filter display the TOP N values? Clearly, N will be equal to 1

[sandip]

Hi,

I have used your idea and having a problem as beacause it asking for a measure like below and what measure should I have to use.Please advise.

[v-diye-msft]

Hi @sandip 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. . others will benefit from here. thanks!

[EVEAdmin · Accepted solution]

Drop your Order Date field in the By Value field.