Set up a chart with the timeline

[DanCasSan]

Hello community, could anyone help me with this query. I would like the chart to change level as I select a date in the Timeline filter. For example, when I select the year, you should show me the graph at the year level (image1); Now, if I select a quarter, it must show me the information by year and quarter (image 2). Thank you!

[v-alq-msft]

Hi, @DanCasSan 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft · Accepted solution]

Hi, @DanCasSan 

I'd like to suggest you use data hierarchy as the axis. Here is my example.

You may use drill up/down to change the level to filter the value.

For further information, please refer to the following link.

Drill mode in a visual in Power BI 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

There is no straight-forward way to do that in the manner you suggest. Perhaps with buttons and bookmarks. Otherwise, you would need a measure but you can't use a measure in an Axis so you would need to use the Disconnected Table Trick. Far easier to simply teach your end users how to use the drilldown feature of visuals with a date hierarchy in the axis. Otherwise you are really just jumping through complex hoops to avoid doing it the way Power BI is designed to work (in other words, drilldown).