Dynamic x axis with date and time

[Anonymous]

I have three column Date, Start time and end time, i want to show the combo chart of line and bar with dynamic x axis, 

1. Last 24 hours

2.Last 12 hours

3.Week days 

4. Month 

Please let me know solution for this 

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You may refer to the similar threads, if need more valuable solution, you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

https://community.powerbi.com/t5/Desktop/Dynamic-Date-Axis/m-p/582859 

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167 

Bookmark could be a workaround:

https://community.powerbi.com/t5/Desktop/Dynamically-switch-between-Date-and-DateTime-on-X-Axis-of-chart/m-p/1025496