cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Evogelpohl
Helper V
Helper V

Dynamic Date Slicer Based on Parameter Choice and Filter

I know this issue has been discussed several times, but I thought I would take another crack at it, with a simple example PBIX.

 

My example PBIX is here: Need Dynamic Date Slicer

 

 

 

Need: I have a report-page that allows users to choose if they want to see the full sales dataset or just the last six months of sales.  That logic works fine.  However, if they choose to filter on just the last 6 months, then the Date Slicer (that lets them fine-tune their range even further) should update/respond logically.

 

Problem: Understand the fundamental issue is that PowerBi doesn't re-calculate Calculated Tables based on filter selection.  They only calc upon refresh, as I've tried to create a SUMMARIZED or CALENDAR Calc'd Table, joined, to be used as the slicer-date *IF* a user has selected Yes or No on the 6-month parameter.

 

Has anyone else come up with a way to present a user with a "Smart Date Filter That Responds To Filter Changes" - as if the Date Slicer is included in the measure being activated - like a Table would respond?

 

Thanks.

2 REPLIES 2
v-cherch-msft
Microsoft
Microsoft

Hi @Evogelpohl

 

It seems you may have a look at this article about How to filter slicers dynamically.Below is a workaround in query editor.

https://community.powerbi.com/t5/Desktop/Dynamically-changing-Date-slicer/td-p/357593

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks, @v-cherch-msft.  I did read that post by Gilbert Quevauvilliers.  It's a similar pattern, I see what he's doing with creating a second FY filter table to put next to a date-slicer, and it works - selecting a date range changes the FY periods slicer.  However, if you take his FY slicer & choose "2019", (my) users expect the date slicer to re-adjust to only show dates within 2019 (1/1/19-12/31/19) - and it doesn't.  I've tried to cross-filter all tables, same.

 

Re; making a table in PQ.  Again, that'll only run on import.  I'd like the date slicer to be dynamic within the context of the resulting filters applied to the calendar table.  

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors