Waterfall Chart / Grow Up Chart

[Dodic]

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.

[v-jiascu-msft]

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

[v-jiascu-msft]

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. 

Question: how to evaluate income?

Best Regards,

Dale

[Dodic]

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]

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. 

Best Regards,

Dale