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.