We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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