Dynamic time hierarchy Filter selection

[Thai_Nguyen96]

Hi Power BI Community,

I'm suddenly view a report with the period filter selection.

When you choose the period in the filter pannel, line chart wil be reflected.

How can we archive this, assume we have data in lowest level (data by daily or hourly)?

View by daily

View by weekly

[Icey · Accepted solution]

Hi @Thai_Nguyen96 ,

There is another way to achieve your requirements. You can try to allow a user to make a slicer selection that dynamically updates the x-axis. Here are some blogs for your reference:

Dynamic X axis on charts - Power BI - RADACAD;

Dynamic Attributes In A Power BI Report - P3 Adaptive;

Solved: Dynamic change in X Axis - Microsoft Power BI Community.

Best Regards,

Icey

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

[amitchandak]

@Thai_Nguyen96 , You need to use bookmark for this

refer

https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmark...
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive