Forum Discussion

jhorta's avatar
jhorta
Frequent Visitor
8 years ago
Solved

Date Slicer for multiple columns in different tables

I'm new in the BI and Power BI world, I'm creating a PoC in PowerBI. My data sources are all scattered, mainly on spreadsheets, and I'm also pulling data from Google Analytics.   In one of my table...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi jhorta,

     

    You need to create a Calendar table and them make a relationship between the tables that way you canuse the calendar table to make the visuals / slicers you need and all the information will be transform based on that.

     

    On this post you can find several ways to create a calendar but if you google "POWER BI Calendar" you will find lots of different ways to create a calendar table.

     

    Just as a best pratice be sure that the calendar table is starting on 1 January and ending on 31 December (this can be different years)

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi jhorta,

 

You need to create a Calendar table and them make a relationship between the tables that way you canuse the calendar table to make the visuals / slicers you need and all the information will be transform based on that.

 

On this post you can find several ways to create a calendar but if you google "POWER BI Calendar" you will find lots of different ways to create a calendar table.

 

Just as a best pratice be sure that the calendar table is starting on 1 January and ending on 31 December (this can be different years)

 

Regards,

MFelix

jhorta's avatar
jhorta
Frequent Visitor
8 years ago

Alright, sounds like I have some more research to do. Thanks!!