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!