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
MauriceMecowe's avatar
MauriceMecowe
Resolver II
8 years ago

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

walkery's avatar
walkery
Helper I
8 years ago

Hi 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. 

  • 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