Replicate JIRA control chart in Power BI

[Anonymous]

Hi,

The above screenshot is from JIRA Control chart. I am trying to replicate that in Power BI.

Below are the key things I want to achieve to populate in Power BI:

1. The blue shaded area of the control chart represents the standard deviation. (Alternatively upper and lower limit)

2. Each dot represents an issue or a group (cluster) of issues and this should be represented in bigger or smaller size of bubble based on the number of issues. When you hover the bubble this should show the list of issues which made that particular bubble small or big in size.

3. X- axis represent issue transition date where in this has to be changed when you change the timeframe. This should not show full dates in x - axis from the dataset.

4. Y - axis shows elapsed time in days.

Lastly I am having hard time in plotting scatter and line charts together in one chart. Please show how this can be done?

Thanks.

[KerKol]

If there is only one point per X-Axis interval, then you could use a line with markers and make the line width 0px to create the scatter. The area could be created using the error bars/error band feature in the Analytics Section.

If there is multiple points per time period, you'll  need to use a custom visual like Deneb.