Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Thanks for the replys.
My problem is different. I'd like to automatically "select" current month in filter visual. An example below.
Current month:
Next month:
Is it possible?
Best Regards
Ferdinando
Hi @ferdinando86 ,
did you see my reply?
I create a column where i renamed the actual month as "Actual Month", to set the default filter on it.
Similar to this..
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |