Slicer not fetching the data properly in Power Bi desktop

[Ramesh4321]

Hello All,

When i filter the date range in slicer, it should fetch both Date 1 & Date 2 but its fetching only Date 2. Both Date 1 & Date 2 are from same table. 

Kindly help me, its an urgent issue.

[Anonymous · Accepted solution]

Hi @Ramesh4321 ,

You will need to create an independent date table and use it as date slicer.

Since you have two date columns to compare with the slicer, you will need to create a measure as below.

measure = if(selectedvalue('table'[date1]) in values(slicer[date]) || selectedvalue('table'[date2]) in values(slicer[date]),1,0)

After that, adding this measure to visual filter and set filter value = 1.

Best Regards,

Jay

[amitchandak]

@Ramesh4321 , Slicer is created on date 1 or date2?

do you date 1 available for a selected range

If you want the same date table to filter 2 dates refer

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...