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 t...
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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper 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