Forum Discussion
Super UserDate Slicer Returns Blank Results When Using Dim_Date to Fact Monthly Costs
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
Super UserThank you. Interesting idea but how this could work if user wants to filter only for exaple 02.01.2025?
Is still not working...
Best,
Jacek
Super User
My understanding was that all dates in a month were the first of that month?
In your initial post you said "if I have data for October, all rows for that month use the date 01-10-2025"
If that is the case why would you have or want a slicer that allows someone to select any other date than the 1st of a month?
And if they could select another date e.g. 2 Oct 2025, what data do you want to be displayed? There is no actual data for the 2nd Oct, so do you show the data for the entire month?
If so, then why bother having any other date in the slicer than the 1st of the month? In fact why have a slicer allowing dates at all? Just use the month slicer.
Please supply your data so that I may understand more clearly.
Phil
- jaryszek
Thank you.
I will disable just monthly slicer tonot be sync with daily one and this will solve the issue.