Forum Discussion

AndreSatziack's avatar
AndreSatziack
Helper I
8 years ago
Solved

help with a simple burndown chart

Hello Team, I need to create a burndown line chart with sample data below. I tried use the follow dax code but don't worked for me, can you help me? Thank you very much.   BurnDown = 180 - CALCU...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    AndreSatziack,

    Create the following measures in your table and check if you get expected result.

    Burndown = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(), 3200 - CALCULATE(SUM(Relatorio_Anual_2017[Hours]),FILTER(ALL(Relatorio_Anual_2017),Relatorio_Anual_2017[Created]<=MAX(Relatorio_Anual_2017[Created]))))
    Burndown1 = IF([Total hours]=0 ||[Total hours]=BLANK(),BLANK(),3200-CALCULATE([Total hours],DATESYTD('Calendar'[Date],"31/12")))



    Regards,
    Lydia

AndreSatziack's avatar
AndreSatziack
Helper I
8 years ago

Hello Anonymous,

 

How are you? Did you get a look at my example?

 

Thank you very much :)

 

Best Regards.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

AndreSatziack,

 

What is your expected result when you set the value to customer1 in visual level filters? And what type of trend line would you like to add?

Regards,

Lydia

  • AndreSatziack's avatar
    AndreSatziack
    Helper I
    8 years ago

    Hello Anonymous,

     

    Thank you for your help.

     

    I resolved the filter problem removing the parameter ALL from FILTER Like "BurnDown = 180-CALCULATE(SUM(Relatorio_Anual_2017[Hours]),FILTER((Relatorio_Anual_2017),Relatorio_Anual_2017[Created]<=MAX(Relatorio_Anual_2017[Created])))"

     

    Your DAX code show me results for each month with subtraction of 180.

     

    I need to show the estimated date of finish hours based on an average of hours used in month like my sample in Excel. How will I calculate this?

     

    Thanks in advance for any help.  I'm still pretty new to Power BI so a lot of this escapes me for now.

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi AndreSatziack,

       

      What result are you expecting when you say "I need to show the expected date of finish........"?

      • AndreSatziack's avatar
        AndreSatziack
        Helper I
        8 years ago

        Hello Ashish_Mathur,

         

        The idea is that a client has a total of 180 hours per year that they can use. I have to calculate this burndown, using the logic that the client starts the year with 180 hours in january, but in february i have to use the resultant burndown from the hours consumed in january instead of 180. I am having difficulties on coding this logic. With that then I will need to show a graph with a trend line.

         

        Thank you very much.