Set time interval with a slicer

[Anonymous]

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.

[avanichheda]

I found a great solution here : Power BI - Dynamic Date Axis Granularity (Drilldown Alternative) - YouTube

Hope that helps!

Regards,

Avani

[parry2k · Accepted solution]

@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.⚡