Forum Discussion

pickslides's avatar
pickslides
Helper I
4 years ago

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  The chart I desire     ...
lbendlin's avatar
lbendlin
Super User
4 years ago

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's avatar
pickslides
Helper I
4 years ago
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's avatar
    lbendlin
    Super User
    4 years ago

    this is all T1 and no fact column?

    • pickslides's avatar
      pickslides
      Helper I
      4 years ago

      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's avatar
        lbendlin
        Super User
        4 years ago

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