Forum Discussion
Time series with custom x-axis
Hi, I want to create a time series in power BI like the following excel chart, but having some problems getting the x-axis to show as required.
My data
The chart I desire
And what happens in Power BI
Thanks, Q
6 Replies
Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.DateManual Term Week 3/02/2022 T1 W1 3/02/2022 T1 W1 4/02/2022 T1 W1 7/02/2022 T1 W2 7/02/2022 T1 W2 7/02/2022 T1 W2 8/02/2022 T1 W2 8/02/2022 T1 W2 8/02/2022 T1 W2 9/02/2022 T1 W2 9/02/2022 T1 W2 9/02/2022 T1 W2 9/02/2022 T1 W2 9/02/2022 T1 W2 10/02/2022 T1 W2 10/02/2022 T1 W2 11/02/2022 T1 W2 11/02/2022 T1 W2 14/02/2022 T1 W3 14/02/2022 T1 W3 14/02/2022 T1 W3 14/02/2022 T1 W3 15/02/2022 T1 W3 15/02/2022 T1 W3 16/02/2022 T1 W3 16/02/2022 T1 W3 16/02/2022 T1 W3 16/02/2022 T1 W3 16/02/2022 T1 W3 17/02/2022 T1 W3 17/02/2022 T1 W3 17/02/2022 T1 W3 17/02/2022 T1 W3 18/02/2022 T1 W3 18/02/2022 T1 W3 18/02/2022 T1 W3 18/02/2022 T1 W3 22/02/2022 T1 W4 22/02/2022 T1 W4 22/02/2022 T1 W4 22/02/2022 T1 W4 22/02/2022 T1 W4 22/02/2022 T1 W4 22/02/2022 T1 W4 24/02/2022 T1 W4 24/02/2022 T1 W4 24/02/2022 T1 W4 24/02/2022 T1 W4 24/02/2022 T1 W4 24/02/2022 T1 W4 this is all T1 and no fact column?
