Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
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?
There is only T1, T2, T3 and T4 in this column, its school related data so T for term and W for week in the term.
Thanks!
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Please see the chart in my original post as my desired output
Q