Forum Discussion

saty's avatar
saty
New Member
5 years ago
Solved

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 ta...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

amitchandak's avatar
amitchandak
Super User
5 years ago

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