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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Sounds pretty straight forward, where did you get stuck?

Reg,

Robin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Robin,

    I've added a screenshot of the data I'm trying to visualise in power BI.

     

     

     

     

     

     

     

     

     

     

    As you can see, the sprint data is on the x axis and is categorical and the y axis is the date the sprint is completed (there will be 2 trendlines, planned finish vs actual finish).

    This is what I'm getting in Power BI.

    As you can see, it's trying to count the sprints, but I need the sprints to be discrete.

    Hope this provides more clarification.


    Cheers.