Forum Discussion
Using Slicer Value to Limit Data
I have a slicer dropdown which is a list of weeks from a table The user selects a week and aggregations of that data (e.g. sales) are shown in various cards on screen I'd also like to have...
You would need to create a measure that does an ALL and then FILTERs that down based upon the date being less than the chosen date. Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490