Min/Max Line Chart

[danb]

Hello, 

I am stumped and turning to the experts! I am trying to benchmark different stores sales for items in a line chart visual. The goal is to have a line graph that with slicers I select the item and a particular store. The catch is I also want to have a line for the store that sold the maximum amount of items as well as the other store that sold the minimum. The thought is that the store selected can then see where they fall in the system. I also don't want the max and min stores identified, just have the line. Here is a mock up of data. 

Here is the data table

Date	Store #	Item	Sales Qty
Jan-18	1	Apples	39
Feb-18	1	Apples	29
Mar-18	1	Apples	5
Apr-18	1	Apples	63
May-18	1	Apples	2
Jun-18	1	Apples	73
Jan-18	2	Apples	66
Feb-18	2	Apples	3
Mar-18	2	Apples	75
Apr-18	2	Apples	59
May-18	2	Apples	5
Jun-18	2	Apples	15
Jan-18	3	Apples	73
Feb-18	3	Apples	18
Mar-18	3	Apples	72
Apr-18	3	Apples	25
May-18	3	Apples	7
Jun-18	3	Apples	95
Jan-18	4	Apples	70
Feb-18	4	Apples	27
Mar-18	4	Apples	84
Apr-18	4	Apples	99
May-18	4	Apples	89
Jun-18	4	Apples	86
Jan-18	5	Apples	43
Feb-18	5	Apples	83
Mar-18	5	Apples	62
Apr-18	5	Apples	23
May-18	5	Apples	45
Jun-18	5	Apples	58
Jan-18	1	Bananas	93
Feb-18	1	Bananas	57
Mar-18	1	Bananas	27
Apr-18	1	Bananas	62
May-18	1	Bananas	86
Jun-18	1	Bananas	99
Jan-18	2	Bananas	63
Feb-18	2	Bananas	53
Mar-18	2	Bananas	48
Apr-18	2	Bananas	93
May-18	2	Bananas	32
Jun-18	2	Bananas	34
Jan-18	3	Bananas	91
Feb-18	3	Bananas	92
Mar-18	3	Bananas	50
Apr-18	3	Bananas	16
May-18	3	Bananas	73
Jun-18	3	Bananas	76
Jan-18	4	Bananas	36
Feb-18	4	Bananas	14
Mar-18	4	Bananas	55
Apr-18	4	Bananas	57
May-18	4	Bananas	11
Jun-18	4	Bananas	94
Jan-18	5	Bananas	14
Feb-18	5	Bananas	81
Mar-18	5	Bananas	21
Apr-18	5	Bananas	100
May-18	5	Bananas	31
Jun-18	5	Bananas	28

Again the end result would be to have 3 lines on the chart. The Max, Min and store selected. Example would be for Apples, the max store would be #4 and the min would be #1. 

Thank you in advance and if there are any questions, let me know. 

Dan

[v-danhe-msft]

Hi @danb,

From your description, I could not understand the sentence “The thought is that the store selected can then see where they fall in the system. I also don't want the max and min stores identified, just have the line.” Could you offer me more information about the logic of calculating max and min store?

Regards,

Daniel He

[danb]

@v-danhe-msft

Sorry for the confusion. Basically what I am trying to create is a line graph with 3 lines. 

1. The store that sold the most (max)

2. The store that sold the least (min)

3. The store that is selected via the slicer. 

[v-danhe-msft]

Hi @danb,

From your description, the max and the min store in different time seem different, I am afraid you could not achieve this feature.

Regards,

Daniel He

[danb]

@v-danhe-msft

Daniel, just so that i understand your response, why wouldn't this work? Is it not possible to have a line or two in a visual that are not subject to the slicer selections or something else? 

Thanks 

Dan

[v-danhe-msft · Accepted solution]

Hi @danb,

Yes, If you select the item in the slicer, it is not possible to have other line in a visual that are not subject to the slicer selections.

Regards,

Daniel He