Date Slicer across multiple tables same Page

Question

Hi All, I have 2 different tables within my PowerBI report that I've used to create 2 seperate visuals on the same page. I'd like to now add a date slicer onto the page that filters both visuals. I read on another post that I'd need to create a relationship between the 2 tables, so I created a date table, dimDate and created a relationship between both tables to that dimDate table and then created a slicer on the dimDate date field. However nothing happens when I change the date parameters. Any ideas of what I'm doing incorrectly? Screenshots below of the relationships I've created, I assume the issue is with that...?

mauricemecowe · Answer

Does your DimDate Table have corresponding&nbsp;rows for the days in your fact table?

walkery · Answer

Hi&nbsp;MauriceMecowe, yes the dimdate table has everyday from 1/1/2000 - 12/31/2020 just to be safe :) the dates of my fact table are only from 2015 - 2018 YTD so it should definitely have the corresponding rows.&nbsp;

anonymous · Answer

Hi walkery&nbsp;Check the cross filter direction. The filter direction should flow from DimDate table to Fact table 1 and DimDate table to Facttable 2.&nbsp;ThanksRaj

walkery · Answer

Hi&nbsp;Anonymous&nbsp;I changed the relationship direction but still nothing happens when I try to filter the date using a date slicer made with the Standard Date field from the dimdate field. Is there anything else I could try? Thanks!&nbsp;

anonymous · Answer

Hi walkery&nbsp;The issue could be because of 2 reasons :&nbsp;1 . The cross filter direction could be wrong - Can you post the snapshot from relationship tab?&nbsp;2. The data between the tables are not matching. Just try to play around :&nbsp;&nbsp;&nbsp; * Create a table visual for FactTable 1, note down the data for a record.&nbsp;&nbsp;&nbsp; * Select that particular date in slicer and see if the table visual responds correspondingly&nbsp;&nbsp;&nbsp; * Do the same for FactTable 2 as well&nbsp;ThanksRaj&nbsp;&nbsp;

Forum Discussion

Date Slicer across multiple tables same Page

7 Replies

Related content

Text slicer: pasting multiple values

Slicer for Multiple-Choice Values

Slicer pointing towards multiple fields

Parameter slicer with measure for multiple columns

new input slicer - how to paste multiple items?