Forum Discussion

B_Real's avatar
B_Real
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

select which filter to use

I have a date dimension that contains the date an event is due to fall on. I have created one additional column to flag if the date occurs within 7 days of today's date, and a second column to flag i...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    B_Real

     

    According to your description, it seems you want to achieve a last X period slicer to filter dates. In this scenario, you need to create a calculated table for each period, and union those calculated tables into a "DatePeriod" table. Then build the relationship to date table for filtering. For more details, please see a blog below:

     

    POWER BI – TIME PERIOD SLICER FOR LAST 7 DAYS,LAST 30 DAYS..

     

    Regards,

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Dont forget that when you add a column which is DateTime format to the canvas and make it a Slicer you get this flexibility now, where the user can adjust the range to get any date range requred.