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 

Another workaround is to create a R visual so that the date field can be used in Y axis.

After transformation as my previous post, create a r visual as below:

https://community.powerbi.com/t5/Desktop/dates-on-Y-axis/td-p/339940

 

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.