Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
pickslides
New Contributor II

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 

data.PNG

The chart I desire 

 

chart.PNG

 

 

And what happens in Power BI

 

PBI.PNG

 

 

Thanks, Q

 

6 REPLIES 6
lbendlin
Esteemed Contributor III

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.

pickslides
New Contributor II

DateManualTermWeek
3/02/2022T1W1
3/02/2022T1W1
4/02/2022T1W1
7/02/2022T1W2
7/02/2022T1W2
7/02/2022T1W2
8/02/2022T1W2
8/02/2022T1W2
8/02/2022T1W2
9/02/2022T1W2
9/02/2022T1W2
9/02/2022T1W2
9/02/2022T1W2
9/02/2022T1W2
10/02/2022T1W2
10/02/2022T1W2
11/02/2022T1W2
11/02/2022T1W2
14/02/2022T1W3
14/02/2022T1W3
14/02/2022T1W3
14/02/2022T1W3
15/02/2022T1W3
15/02/2022T1W3
16/02/2022T1W3
16/02/2022T1W3
16/02/2022T1W3
16/02/2022T1W3
16/02/2022T1W3
17/02/2022T1W3
17/02/2022T1W3
17/02/2022T1W3
17/02/2022T1W3
18/02/2022T1W3
18/02/2022T1W3
18/02/2022T1W3
18/02/2022T1W3
22/02/2022T1W4
22/02/2022T1W4
22/02/2022T1W4
22/02/2022T1W4
22/02/2022T1W4
22/02/2022T1W4
22/02/2022T1W4
24/02/2022T1W4
24/02/2022T1W4
24/02/2022T1W4
24/02/2022T1W4
24/02/2022T1W4
24/02/2022T1W4
lbendlin
Esteemed Contributor III

this is all T1 and no fact column?

pickslides
New Contributor II

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!

lbendlin
Esteemed Contributor III

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

pickslides
New Contributor II

Please see the chart in my original post as my desired output

 

Q

 

 

Helpful resources

Announcements
Users online (3,586)