Forum Discussion
Solved
Switch between two date options based on Filter
I have read many different versions of this question, this one here nearly gets what I want: https://community.powerbi.com/t5/Desktop/Filter-records-between-two-date-columns-with-one-slicer/m-p/82511...
Hi Sam7 ,
I updated my sample pbix file(see attachment), please check whether that is what you want.
1. Create a date type dimension table by Enter data method
2. Create a date dimension table and apply the date field on the slicer
Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))3. Update the formula of measure [qty] and [ssales]
Best Regards
Sam7 , You can create an active inactive relationship and create two measure and switch those using measure slicer
example
Order =calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[order date], 'Date'[Date])
Ship = calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[shipped Date], 'Date'[Date])
For measure slicer use field parameters