Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
10 months ago
Solved

Date Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs

Hello everyone, I’m working with a model where Dim_Date contains a daily date column (e.g., 01-03-2025). My fact table (Monthly_Costs) is connected to Dim_Date using a 1-to-many relationship (D...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    10 months ago

    jaryszek 

     

    Updated: Download example PBIX file

     

    Add a column to your date table that is the first of the month for each date e.g.

     

     

    Then use that First Date column in the date slicer.  It will work fine with your month slicer, which is presumably getting the month from the same date table.

     

     

     

     

     

     

     

    Phil

raisurrahman's avatar
raisurrahman
Icon for Helper II rankHelper II
10 months ago

I noticed that your Monthly Cost fact table is at a monthly grain. Therefore, you need to align your Date dimension to match this granularity. For example, if you build a Date dimension for the year 2025, it should contain exactly 12 rows, with each row representing the first date of the month.

  • jaryszek's avatar
    jaryszek
    Icon for Super User rankSuper User
    10 months ago

    Thanks! That would work for a very simple case, but I need daily slicing too — so a 12-row Date table isn’t sufficient.