Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
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.
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
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |