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 the different projects - 48 different sprints - (so a categorical variable).

I was able to do it in excel (picture below), and I'm trying ot accomnplish this in power BI.

Please help.

 

Cheers

 

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.

4 Replies

Replies have been turned off for this discussion
  • 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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community 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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community 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.