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.
I have a dashboard with a Slicer, which contains a date field. The slicer is configured as Between.
The dashbboard is refreshed every day.
I would like the slicer, each day, to have the interval Today and Today - 10 days (for example).
Of course, the slicer must continue to be edited.
Can this be acomplished?
Thank you for any help
Solved! Go to Solution.
Nobody has a solution?
Did you find a solution ? I am now trying to do the same thing .
Would be very helpful if you could share your solution .
Thank you in advance !
@Anonymous : did you find the solution i am also doing the same
Hi nranito ,
So your requirement is to create a dynamic calculate date column between today and 10 days previous, then create a slicer chart based on the column, right? If it is, I'm afraid power bi doesn't support dynamic calculate column. In addtion, you can submit your idea about improvement of slicer chart here: https://ideas.powerbi.com.
Regards,
Jimmy Tao
I have a table with dates.
Let's say a year
My slicer must choose an interval inside that year
What I want is to be started with a default value (interval)
One approach might be to make a custom calendar table that pulls today's date as the end point and today's date -10 as the start point and then relate that to your main calendar?
But can I still change the calendar like that?
Because I want those as default, but still want to maintain chance of choosing any random dates outside that range
Ah, I see what you mean now, that's not going to work for what you want
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |