Forum Discussion

IgorS's avatar
IgorS
Regular Visitor
4 years ago
Solved

One Slicer or filter for different date columns

Hello,

 

I have on one page in PB different visualizations. For example one is sell value and another is order value. They come from different tables. Is it possible to make slicer where I change the date and both visualizations will show data only from that period of time? I know only how to do slicers for each of them separatly but it would be easier to use only one.

 

Best regards,

Igor

Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi IgorS ,

     

    You need to create a calendar table either in Power Query or DAX (plenty of examples available online).

    Create a relationship between calendar[date] and the date fields in each of your fact tables.

    Use the calendar[date] field in any slicers and visualisations.

     

    Pete

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi IgorS ,

     

    You need to create a calendar table either in Power Query or DAX (plenty of examples available online).

    Create a relationship between calendar[date] and the date fields in each of your fact tables.

    Use the calendar[date] field in any slicers and visualisations.

     

    Pete