Forum Discussion

Consta's avatar
Consta
Frequent Visitor
4 years ago
Solved

Burndown Graph for projects based on date

Hello all. I have already started a topic here, but now I would like to be more specific. So far I have created and used a burndown chart in Excel, now I want to display the same in Power BI. The ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Consta 

     

    I started by creating a calendar table to get consecutive columns of dates. Then create three measures to be used as values. I put my pbix file in the attachment you can reference.

    Result :

     

    In fact, if the date starts too long, you might consider using this setting below to specify the time period you need.

     

    If something wrong, please let me know.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Consta's avatar
Consta
Frequent Visitor
4 years ago

I understand thank you!

When I use the measures for the planned end dates (I adapted the measure to refer to this column) I get a gap from the remaining projects. X Axis is on categorized. Do you know a fix for this?

When i choose continous this problem is fixed but i only can see january and july in the drilldown not the quarters. So its 2020 July, 2023 January etc.. instead of 2020-Q3,2020-Q4..

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi,@Consta

Yes,when catagorized, it will be 2020-Q3,2020-Q4. But with continous, it will be a continuous X Axis. I thought about using this approach at first, but I saw that your requirement was in the form of something like 2020-Q3, so I chose to write measure to achieve it. There is no way to fix it directly at the moment, you can suggest it in power Bi ideas.
I see that your chart still has the early start quarter, trying to use a combination of if() and blank() will keep it from showing.

  • Consta's avatar
    Consta
    Frequent Visitor
    4 years ago

    How exactly should i use if() and blank()? 

    Thanks for the help.

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago
      end =
VAR _c =
    CALCULATE(
        DISTINCTCOUNT( 'Table'[Project Name] ),
        FILTER(
            'Table',
            [Planned end date].[Quarter] = SELECTEDVALUE( 'Table 2'[Date].[Quarter] )
                && [Planned end date].[Year] = SELECTEDVALUE( 'Table 2'[Date].[Year] )
        )
    )
RETURN
    IF(
        SELECTEDVALUE( 'Table 2'[Date].[Year] ) <= 2020
            && SELECTEDVALUE( 'Table 2'[Date].[QuarterNo] ) < 3,
        BLANK(),
        _c
    )
      • Consta's avatar
        Consta
        Frequent Visitor
        4 years ago

        Nothing changes with this solution, sadly 

        The X axis still starts at 2020 Q2, not 2021 Q2