Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gsksarepta
Helper II
Helper II

3Std.Dev limits on parellel line chart with multiple categories

I have this parellel line chart in Power Bi desktop with 3 separate categories on X axis and multiple runs and their yields on Y axis displayed in different colors. I want to add 3 std. dev lines for each of this category as upper and lower limits to this same chart. Because each category have its own std.dev limits, it wont be a straight line but follows the trend of how most other runs are aligned. Can I know how can I display the +/- 3 std.dev values as upper and lower limits to this chart? Additionally an average line as well.. Thanks in advance. 

e8a20b89-2ef9-4eb1-9d0c-77e535a7978c.png

2 REPLIES 2
gsksarepta
Helper II
Helper II

No, this gives me the static average line. Here I need average line with different average (and Std.dev) values for each category on X axis

v-jingzhang
Community Support
Community Support

Hi @gsksarepta 

 

For average lines, you can switch to below ribbon and try "Average line" there. 

vjingzhang_1-1665134107162.png

For 3 std. dev lines, currently I cannot imagine what it should be like on the chart. If every category has upper and lower limits, it seems to be two points for every category on the line chart. 

 

Best Regards,
Community Support Team _ Jing

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.