Forum Discussion
Helper VCreate a toggle for the most recent date in a table
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?
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-date-when-data/m-p/3996537/highlight/true#M1275290It 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
1 Reply
- Ritaf1983
Super User
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-date-when-data/m-p/3996537/highlight/true#M1275290It 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