Forum Discussion
Helper VSet up a chart with the timeline
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!
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.
3 Replies
- Greg_Deckler
Community Champion
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).
v-alq-msftCommunity Support
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.
- 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
