Filter on Single Date to display data between 2 dates.

Question

Is it possible for me to build a Dax / funtionality that will allow me to have one date filter / slicer that will then return all rows between a start and end date range?

For example from the table below. If i select 01/02/2021 or 30/02/2021 it will show me rows for Event 3&4.

And if i selected 14/01/2021 it would show me Event 1, 2, 3 % 4.

If anyone could assit me with this i would be most greatful indeed, i have tried everything i can think of with regards to this.

mahoneypat · Answer

You can use a measure pattern like this and use it as a filter on your table visual where it "is" 1
&nbsp;
EventFilter&nbsp;=VAR&nbsp;vSelDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE&nbsp;(&nbsp;SlicerTable[Date]&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNT&nbsp;(&nbsp;Event[Event&nbsp;Name]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Event[Start&nbsp;Date]&nbsp;&lt;=&nbsp;vSelDate,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Event[End&nbsp;Date]&nbsp;&gt;=&nbsp;vSelDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;
Pat

Forum Discussion

Filter on Single Date to display data between 2 dates.

1 Reply

Related content

Dynamic Filter Display

Image display in Power bi report

Filter

Visual Display based on Filter/slicer election

remove filter display