Trying to create Control Chart in Power BI same as in JIRA

[akshata_patil]

olHi,

The below 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.