Forum Discussion
Set time interval with a slicer
Hi,
Is it possible to create a slicer where you can select the time interval of one or multiple visuals?
So for example:
I have a clustered column chart where I set the time interval to every 15 minutes. Then I want to create a slicer next to it where the user have the option to change this interval form every 15 min to every 30 min, 45 and 1 hour.
I hope i'm clear enough. Please ask if not.
Anonymous you are looking to change x-axis dynamically, it is not that straight forward but still achievable. One way is to use bookmark and selection to change the visual with the different axis or allow users to personalze visualization so that they can pick their own axis.
Here are few videos on the dynamic x-axis
https://www.youtube.com/watch?v=FzYO6TMseGs
https://www.youtube.com/watch?v=lFd2hjkKz_Q
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
2 Replies
- parry2k
Super User
Anonymous you are looking to change x-axis dynamically, it is not that straight forward but still achievable. One way is to use bookmark and selection to change the visual with the different axis or allow users to personalze visualization so that they can pick their own axis.
Here are few videos on the dynamic x-axis
https://www.youtube.com/watch?v=FzYO6TMseGs
https://www.youtube.com/watch?v=lFd2hjkKz_Q
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
- avanichheda
Microsoft Employee
I found a great solution here : Power BI - Dynamic Date Axis Granularity (Drilldown Alternative) - YouTube
Hope that helps!
Regards,
Avani