The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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