Solved: Dynamic x axis with date and time

Anonymous · ‎05-27-2020

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 · ‎05-27-2020

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post