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
Anonymous
Not applicable

Multiple Lines in Line chart

Hi,

 

I try to visualize curves with a spefic min and max line. In a line chart I am able to select more than one curve and I am able to see the graphs. But it is not possible to add the min and max per curve. The Min and Max value is spefic per

LineChart.PNG

 

If I use the Line and clustered column chart it is not possible to add the Legend. In this case Max and Min for all curves are the same but normally they are curve spefic.

 

Line and Cluster.PNG

 

Is there another line chart where this requirement is possible? Or do someone know another solution?

6 REPLIES 6
v-juanli-msft
Community Support
Community Support

hI @Anonymous

First, please know that you could add a "max/min" line With the Analytics pane in Power BI Desktop.

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

However, it only show the max/min value of [Median of Torque], it can't distinguish from differnce categories.

 

"min and max per curve" should be added as a line or marker on the line chart?

 

"min and max per curve" means for every "Angel" point, the max/min value among three lines,

Or means that for each line, for example, when "source.name" is "Ch_0000000230", the max value is 3, the min value is 0.1.

Which understanding is right?

 

If first is right, as a workaround please refer to my pbix->page 2

create new measures to replace previous ones

value_a = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="a"))

value_b = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="b"))

value_c = CALCULATE(SUM(Sheet1[median of t]),FILTER(Sheet1,[category]="c"))

max = CALCULATE(MAX(Sheet1[median of t]),ALLEXCEPT(Sheet1,Sheet1[angle]))

min = CALCULATE(MIN(Sheet1[median of t]),ALLEXCEPT(Sheet1,Sheet1[angle]))

6.png

 

 

If the second one is right, please refer to  to my pbix->page 3

create three Max lines and Min lines separately based on [value_a],[value_b],[value_c].

 

5.png

 

Best Regards

Maggie

Anonymous
Not applicable

Hi @v-juanli-msft,

 

many thanks for your answer.

 

But as you say "it can't distinguish from differnce categories." and thats what I need. A min and max line which is selectable by category.

Range1.pngRange2_Category_Selected.png

 

 

Best regards

Timo

Hi @Anonymous

You are welcome.

It is glad that you seems to find what you want.

 

Thank you for making more realized about your requirement.

I say "it can't distinguish from differnce categories", it is ture when you don't select any item from the slicer, it only show max'min value for all categories.

When you select a item from the slicer, then the max/min value would change according to the selected item.

 

Best Regards

Maggie

 

Anonymous
Not applicable

Hi @v-juanli-msft

 

the min/max value changed according to my selected item, but I am not able to display the lines in the chart.

It is only possible to select a item in a slicer or display the min/max value (of all). Both is impossible at the moment. Or am I wrong?

 

BR

Timo

Hi @Anonymous

Does this meet your needs?

12.png

Please see the Pbix->page 1

Anonymous
Not applicable

Hi @v-juanli-msft,

 

no. My min/max line is more a range. The range for category c is 12 and 15.

 

The max value of the curve is 18 and min value is 0. So that I am able to display by min and max line. But I like to display the range lines. So I need a line at 12 and 15.

 

 

BR
Timo

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.