How to simultaneously display two or more timescales on an X axis?

[elosilla]

I want to show the information of the last 12 months in a graph.
However I would like to show a different level of detail based on proximity to the current date. In other words, I would like to see in the same graph the last 5 days, the previous 3 weeks and the previous 11 months.
Is it possible with PBI?

[Anonymous · Accepted solution]

Hi @elosilla ，

You can consider creating a custom column to store the value of x-axis.

Best Regards,

Jay

[lbendlin]

yes, that can be achieved by preparing the data accordingly either in a calculated table or in Power Query.

Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.