Forum Discussion

Evogelpohl's avatar
Evogelpohl
Icon for Helper V rankHelper V
7 years ago

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...
Need Help
Evogelpohl's avatar
Evogelpohl
Icon for Helper V rankHelper V
7 years ago

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.  

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It currently is a limitation to use relative date slicers with a dyanmic query parameter. 

    The dynamic query paramter is a fairly new feature in 2022 but at least its acknlowedged by the Power BI team.

     

    You can see the limitations here:

     

    • Unsupported filters:

      • Relative time slicer or filter
      • Relative date
      • Hierarchy slicer
      • Multi-field include filter
      • Exclude filter / Not filters
      • Cross-highlighting
      • Drill-down filter
      • Cross drill filter
      • Top N filter