Different date sources in one slicer

[Matthias93]

Hi,

I'm currently working on a dashboard that gets data from 3 different SharePoint lists. I want to be able to slice my visuals according to date. However I have 3 date columns in different tables because I am using different lists. Is there a way to put all these date columns into one slicer? An example would be to just have: January, February, March,... in one slicer and that when I select the month the visuals will only show all data for the month I selected. I want to try to avoid using three different date slicers.

Thanks in advance,

Matt

[v-shex-msft · Accepted solution]

Hi @Matthias93,

You can use union function to merge these data fields to a new table and create the relationships between these fields, then use the new table as the slicer data source.

Sample:

formula:

Table = DISTINCT( UNION(VALUES(Sheet4[Date]),VALUES(Sheet5[Date]),VALUES(Sheet6[Date]))) 

Regards,

Xiaoxin Sheng

[blopez11]

I believe if you leverage a date table, relate it to each of your sharepoint sources using the datekey in those, then use the date from the date table in your slicers, you should be able to achieve what you want

There a many posts on creating a date table

Hope this helps,

[Matthias93]

Thank you,

I created the date table as you suggested, however I am not able to create the correct relationships between that table and my other ones. Can you have a look at this screenshot please?

Thank you,

Matt

[blopez11]

Relate the date fields, not the month fields, then use the monthname field from the date table drive your slicers