Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Project Tracking

  Hi there,   I'm trying to create a project tracking chart, whihc is basically a project managemnet S curve. The only difference is my X axis is date (so continuous variable) and my Y axis are t...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Line chart doesn't support to use "date" in the y-axis.

     

    One workaround is as below:

    Open Edit queries,

    Click on "sprint" column, then select add column- duplicates column,

    Click on the duplicated column, then select transform->split column,

    Select "planned" and "actual" columns, then select transform->unpivot columns,

    Close && apply,

     

    Create another table and connnect it with original table

    calendar = CALENDARAUTO()

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

Line chart doesn't support to use "date" in the y-axis.

 

One workaround is as below:

Open Edit queries,

Click on "sprint" column, then select add column- duplicates column,

Click on the duplicated column, then select transform->split column,

Select "planned" and "actual" columns, then select transform->unpivot columns,

Close && apply,

 

Create another table and connnect it with original table

calendar = CALENDARAUTO()

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.