Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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