Forum Discussion

walkery's avatar
walkery
Icon for Helper I rankHelper I
8 years ago

Date Slicer across multiple tables same Page

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 r...
Need Help
walkery's avatar
walkery
Icon for Helper I rankHelper I
8 years ago

Hi Anonymous 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! 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi walkery

 

The issue could be because of 2 reasons :

 

1 . The cross filter direction could be wrong - Can you post the snapshot from relationship tab?

 

2. The data between the tables are not matching. Just try to play around :

    * Create a table visual for FactTable 1, note down the data for a record.

    * Select that particular date in slicer and see if the table visual responds correspondingly

    * Do the same for FactTable 2 as well

 

Thanks

Raj