Forum Discussion

Dodic's avatar
Dodic
Frequent Visitor
8 years ago

Waterfall Chart / Grow Up Chart

Hello,

 

I'm absolutly new to Power BI and I want to ask you guys how I can show in a chart the grow up for our tickets.

 

What I have at this moment.

 

CreationDate

ClosedDate

Tickets

Vergleich-Geschlossen (if ticket is open or closed)

 

So, how I can show up the grow up or down of our ticket income for each year? Is there an example anywehere?

 

Here is a screenshot of my data table.

 

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Dodic,

     

    This file could give you some ideas. 

    1. I would suggest using a date table.

    Calendar =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2017, 1, 1 ), DATE ( 2019, 12, 31 ) ),
    "Year", YEAR ( [Date] )
)

    2. Create a visual. 

    Waterfall_Chart_Grow_Up_Chart

     

    Question: how to evaluate income?

     

    Best Regards,

    Dale

    • Dodic's avatar
      Dodic
      Frequent Visitor
      8 years ago

      Hey,

       

      thanks for your answer v-jiascu-msft, but you are right. The question is how to evaluate the income. I think it would help, if I would have a table, with all open tickets at the end of a month. Then I could insert a line for current open tickets to my chart, what do you think?

       

       

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Dodic,

         

        Maybe not. Do you want to count the quantity of tickets or the income of tickets? Did you try the file I shared with you? Maybe you can use date hierarchy in the Axis. 

        Waterfall_Chart_Grow_Up_Chart2

         

        Best Regards,

        Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Dodic,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale