Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Adapting to Units on a Relative Date Slicer

Hey all,


Is it possible to adapt grouping based on the unit of time selected in a Relative Date Slicer?


Take the slicer below as an example:


If a user changed the slicer from months to weeks, how would you, for example, change a bar chart's axis to then group on weeks instead of months? Is this selection accessible as a variable?



Super User
Super User

@jribs that is not possible, the only way is to provide a drill down on the visual.


Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at, your one-stop-shop for Power BI-related projects/training/consultancy.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

Ted's Dev Camp - October 6, 2022

Watch the playback of Session 26 with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors