topic Re: Slicer range compared with another column power bi dax in DAX Commands and Tips

Slicer range compared with another column power bi dax

Anonymous — Fri, 19 Jan 2024 17:26:21 GMT

Hi Team,

I have table visual in my report that filter by the slicer values with some conditions.

Slicer

We have given startdate column in the slicer

For Example, If i selected range between 1-Dec-2023 To 31-Dec-2023.

Case 1: If EndDate is between the slicer Range then we have to show those records in Table

Start Date Enddate

15-Nov-2023 15-Dec-2023

For above record enddate : 15-Dec-2023 is between slicer range values (1-Dec-2023 To 31-Dec-2023) so we need to show above record in table.

Currently it is filtering the values which seleted by slicer range dates.The problem is slicer we have given one column(Startdate) and condition has to check in another column(Enddate)

File Link: Table records_slicer.pbix

Please help me on this and didn't get thought how to solve?

Thanks,

Devansh.

Re: Slicer range compared with another column power bi dax

Stachu — Sat, 20 Jan 2024 12:51:27 GMT

At the moment the slicer is set on the column Sheet1[FirstSuppStartDate], the easiest way to get the behaviour you explained is to replace it with the Sheet1[FirstSuppEndDate]. This will reset the visual, so to get the same look & feel you will need to:

rename the field name in the visual to Date
and switch the slicer type to between

Re: Slicer range compared with another column power bi dax

Anonymous — Mon, 22 Jan 2024 08:54:10 GMT

Hi Stachu ,

As per your suggestion,We have given Enddate column in the slicer

For Example, If i selected Slicer range between 1-Dec-2023 To 31-Dec-2023.

Case 2( Below records also need to show in the table)

Start Date Enddate

15-Nov-2023 10-Jan-2024

If enddate(10-jan-2024)>selected slicer enddate( 31-Dec-2023) also we should display because event not completed but this record in the selected date range so we have to display above record.

Thanks in Advance.

Deva.