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 Vergl...
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