Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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
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?
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
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |