Forum Discussion

walkery's avatar
walkery
Helper 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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi walkery

 

Check the cross filter direction. The filter direction should flow from DimDate table to Fact table 1 and DimDate table to Facttable 2.

 

Thanks
Raj

walkery's avatar
walkery
Helper 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