Work Item Age - how do I get the status order to match my status order?

[nbrown02]

My work item age chart does not match the order of the columns in my kanban board? How do I fix this?

[nbrown02]

1. First of all you need to understand the order of your statuses in Jira, if you choose 'Configure Board'

You will get this view:

2. Next we need to go Power BI and click 'Enter Data'

3. Next we need to enter data for our statuses and the order they should appear in, so for this example it would be like so:

Once done click 'Load'

4. Next we need to click 'Modeling' and 'Manage relationships'

5. Then we need to create a 'New relationship' between our StatusOrder table and our WorkItems InProgress table:

6. Click 'Save' and then 'Close' the relationships view

7. In our 'WorkItems InProgress' table, add a new column of:

StatusOrder = RELATED(StatusOrder[Order])

8. Select the column 'Column Name' then 'Column Tools'

9. Then 'Sort by column' and choose 'StatusOrder'

10. Go to the Work Item Age chart, and ensure this is sorted by Column Name in 'Sort ascending' order: