Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Attached is how my data is shaped and i have also attached an pbix with the same data.
In the raw data i have total 136 tickets (100 in aug and 36 in Sep). Out of these 88 were closed in Aug and 26 were closed in Sep, remaining 20 are still in progress.
I would like to show ticket Created and Closed tickets in each month for e.g. as per the data for the mont of august i should have 100 as created and 88 tickets as closed. When i am plotting the numbers on the graph i am getting the result as below Created 100 and Closed 90 wherein i should get 88 as closed.
Hi @Anonymous ,
Your .pbix file and raw data is unreachable,pls modify the access setting and reupload it to us.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hello @Anonymous
Can't access the file. I guess you need to update the sharing rights.
Cheers!
Vivek
Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter
@Anonymous , Yet to check Pbix. But refer to this blog that deals with Start/Created, end /Close and Current/open. If this can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |