Forum Discussion

Nudo's avatar
Nudo
Icon for Helper I rankHelper I
4 years ago
Solved

Slicer with filtering visuals with 2 different date columns

Hey Pretty new to Powerbi. I've created a report and need to filter a visual based on 2 created dates on 2 different tables with a dropdown slicer. I've created a date table and made a relationshi...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Nudo 

     

    For the first issue, your guess is correct. So in those two tables, add a Date column to have only date values from Created Date column. Change data type of the new column to Date instead of Datetime to remove timestamps. 

     

    In Date table, also change the data type of Date column to Date. Then create relationships on Date columns. In a slicer, you can drag Year, Quarter, Month columns to it at the same time to make a hierarchy slicer. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Nudo 

 

For the first issue, your guess is correct. So in those two tables, add a Date column to have only date values from Created Date column. Change data type of the new column to Date instead of Datetime to remove timestamps. 

 

In Date table, also change the data type of Date column to Date. Then create relationships on Date columns. In a slicer, you can drag Year, Quarter, Month columns to it at the same time to make a hierarchy slicer. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.