Create a toggle for the most recent date in a table

[JemmaD]

Hi there,

I have a data table which has values by date. I have a measure which sums the values in a table.

I want users to be able to see the data either by all dates, or by the most recent date. I don't want them to have to pick the most recent date from a slicer, I would rather have a toggle button which says 'All Dates' and 'Latest Date' and they can pick? Is this possible? If so, how? 

[Ritaf1983 · Accepted solution]

Hi @JemmaD 
Please refer to my answer in the lined discussion :
https://community.fabric.microsoft.com/t5/Desktop/PowerBI-Date-slicer-not-extending-to-the-latest-da...

It includes pbix with the example

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly