Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI Created vs. Resolved Chart

Blair Zagata
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 20, 2025

How does the built-in Atlassian created vs. resolved gadget work, it shows that we resolve more issues then are created a day,  Screenshot 2025-08-20 141936.png

however in Jira custom reports and Power BI is shows that we never resolve more tickets then are created, Screenshot 2025-08-20 142317.png I have gotten it to work in Power BI but now have the issue of date slicers breaking the graph, this is what it should look like, Screenshot 2025-08-20 142558.png

and this is what it looks loke with a date slicer, Screenshot 2025-08-20 142714.png

how do I set up a created vs resolved graph in Power BI that works with date slicers and shows the true count of tickets created and resolved in a day (like the gadget), I have attached an example Power BI report so you can see what I am doing, I am querying the database directly, and would like to not use any plugins   

Jira date table and Created vs closed table Help.pbix 

jira data.xlsx    

 

0 answers

Suggest an answer

Log in or Sign up to answer