Shaded standard deviation on line graph

[nufffins]

Hello!

I am having trouble understanding error bars. I have data with average lines and i want to add the standard deviation as shaded area, but I only manage to show the upper error. the picture is the same, whether I add "standard deviation of value" to upper or lower bound (relative relationship). If I add it to both, there is no shaded area.

See the example image:

Is there a way I can show the error without adding average and upper/lower bound columns in power query? As the number of parallels differs and the dataset is huge, it is not a good option.

This is the result I want:

Here is an example dataset: https://docs.google.com/spreadsheets/d/1AfsS-dRbMLTaUgbwfJOwk0GAhKJBhdFe/edit?usp=sharing&ouid=11106...

[nufffins]

The issue was solved with PowerBI update.

[nufffins]

I hoped there would be solution when I am back from vacation but I am still struggeling with the same problem. Please help!

[v-luwang-msft]

Hi @nufffins ，

Try to create one and add to line chart， refer:

https://community.powerbi.com/t5/Desktop/Standard-Deviation/td-p/66609

Best Regards

Lucien

[nufffins]

The provided link does not deal with error bars