Control chart - line chart + scatter + different shapes

[Anonymous]

I need to produce a control chart as such in Power BI:

Normally I do it by creating 7 different series on top of each other in Excel or other BI tools:

• Upper control limit (top one) - lline series
• Lower control limit (bottom line) - line series
• Average (middle line) - line series
• Value line (black line connecting dots) - line series
• Blue dots - scatter
• Red squares - scatter
• White squares - scatter

Each series will have its own data set with gaps where the series is not supposed to display data.

I have not been able to do this in Power BI.  There are limitations with the line series.  The scatter series does not look suitable for this.

Any help will be appreciated

[v-lili6-msft]

hi, @Anonymous

Do these 7 different data set have the same key column?

If so, you could create a fact table for the key column and then create a relationship between them.

then you can format some of shape of line in Format and add Analytics line for it.

https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane

Best Regards,

Lin