Forum Discussion
Date slicer using Between
Hi All,
I am new to Power BI and had one query. When I use date slicer in my report using 'between' option, I see future dates when I select a date in my calender which are not present in my Date table. So is there a way to only show the dates in the calendar that are in my table. Please help me with it.
Thanks in advance,
Regards,
Saty
Hi saty ,
The description is confusing. Do you have two tables? One is a calendar table, the other is a fact table but contains dates?
Try to create a measure like this and apply it to visual level filter:
Measure = IF(MAX('calendar'[Date]) in VALUES(financials[Date]),1,0)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
saty , Date slicer can not show dates beyond the calendar date column( I doubt it can). If it is created on the date column of the calendar.
If case you want to restrict it on fact dates. You can take the measure from fact put it on visual filter slicer and use not blank, this will filter dates based on fact.
refer this : https://www.youtube.com/watch?v=cyOquvfhzNM
Hi saty ,
The description is confusing. Do you have two tables? One is a calendar table, the other is a fact table but contains dates?
Try to create a measure like this and apply it to visual level filter:
Measure = IF(MAX('calendar'[Date]) in VALUES(financials[Date]),1,0)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
