Forum Discussion
Advanced filtering slicer
Hey! I have a sliding slicer where you can select a range of dates you want to see the visuals in. I am trying to make another visual (a table) that shows how many tickets were open during a specific time frame. I was thinking about using advanced filter settings on the table, such as only counting those in which the closing date is greater than that of the maximum slicer value, however the advanced settings only allows for a manual input. If anyone knows how to help/has any ideas that would be greatly appreciated 🙂
Hi,
Here is one way to do this:
Data:
Relationships:Calendar and table 33 don't have any relationship
Dax:Filter based on max date = var _mdate = MAX('Calendar'[Date]) return
IF(MAX('Table (33)'[Date])>=_mdate,1,0)
Place the measure like this:
Now since the range has 9.9.2023 selected only the last two values are shown.
When another date is selected the values change:
1 Reply
- ValtteriN
Community Champion
Hi,
Here is one way to do this:
Data:
Relationships:Calendar and table 33 don't have any relationship
Dax:Filter based on max date = var _mdate = MAX('Calendar'[Date]) return
IF(MAX('Table (33)'[Date])>=_mdate,1,0)
Place the measure like this:
Now since the range has 9.9.2023 selected only the last two values are shown.
When another date is selected the values change: