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

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

  • walkery's avatar
    walkery
    Icon for Helper I rankHelper 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
        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!