Forum Discussion
ferdinando86
6 years agoNew Member
Selecting filter items dynamically
Hi all, is it possible to select a filter item dynamically? Example: select current month in a months list. Thanks.
v-alq-msft
6 years agoCommunity Support
Hi, ferdinando86
Based on your description, I created data to reproduce your scenario.
Table:
You may create a measure like below.
IsDisplay =
var _date = SELECTEDVALUE('Table'[Date])
return
IF(
MONTH(_date)=MONTH(TODAY())&&
YEAR(_date)=YEAR(TODAY()),
1,0
)
Then you need to put the measure in the visual level filter. Here is the result. Today is 4/9/2020. So the result displays the data on 4/1/2020 and 4/2/2020.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.