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.

V-lianl-msft's avatar
V-lianl-msft
Community Support
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.