Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks,
I'm struggling to get a "Between" Date Slicer to adjust its range to the start date I'm setting using a Date selector. Here are the details:
I have a date selector which is using a switch and a measure to filter out dates before the selected start date on all of my visuals:
Date Range = IF([Start Date]>=MAX('Calendar'[Calendar Date]),1,0)
This is working as intended but my users are requesting a timeline date slicer in addition to the Start date selector:
This is also working except for the fact that the lower bounds isn't being set by the Start date selected in the Date Range Selector.
Any Ideas on how to get this to work? Also I'm curious if there would there be a better way to filter the date range of my visuals using a dynamic start date selector. Having to use a measure as a flag in the visual filter of each idividual visual seems shody. Any help is incredibly appreciated, you're all amazing people 🙂
Solved! Go to Solution.
Hi @Campslol ,
Create a measure as below and make the slicer filtered by it. After that we should edit the interaction of the two slicers to make it work.
Measure = IF( MAX('Calendar'[Calendar Date])>= [Start Date],1,0)
For more details, please check the pbix as attached.
Hi @Campslol ,
Create a measure as below and make the slicer filtered by it. After that we should edit the interaction of the two slicers to make it work.
Measure = IF( MAX('Calendar'[Calendar Date])>= [Start Date],1,0)
For more details, please check the pbix as attached.
Thanks @v-frfei-msft!
That solution is perfect but it's not available on my version of Desktop 😞
I'll just wait until I get the update. Thanks for everyone's input.
Hi @Campslol
If I resolve your problem Mark it as a solution so that it will help others.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
Hi @Greg_Deckler & @amitchandak,
Thanks for your replies! Unfortunately I can't share the original .pbix but I've created a sample file.
The main issue is that my Start date filter doesn't limit the Calendar Date timelime filter:
I'm open to different ways of setting up the date filtering if you have any suggestions!
Cheers,
I created a formula like this and added it to the table.
Measure = CALCULATE(COUNT('Contract Header'[Contract #]),USERELATIONSHIP('Calendar'[Calendar Date],'Contract Header'[Start Date]),CROSSFILTER('Calendar'[Calendar Date],Sales[Date],None))
File attached at after signature
Hmm, this looks like an interesting issue although off of the top of my head I an not sure there is a solution. Can you post your PBIX or sample/example data. I think it would be interesting to look at.
When you select 12 months, it selects the correct end date, not the start date. Can you explain with example
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |