Forum Discussion
Multiple Lines in Line chart
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]))
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].
Best Regards
Maggie
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.
Best regards
Timo
- v-juanli-msft7 years agoCommunity Support
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
- Anonymous7 years agoNot applicable
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
- v-juanli-msft7 years agoCommunity Support
Hi Anonymous
Does this meet your needs?
Please see the Pbix->page 1