In my report, I have something like 10 slicers (filters). I want to be able to vizualize on my graphic different selections at the same time.
For example, the sales volume on the last 12 months. I want to see :
- the global sales volume
- the sales volume for item under 10$
- the sales volume for item above 10$
Then maybe i will want to vizualize :
- the global sales volume
- the sales volume for high tech item
- the sales volume for non high tech item
It means that i cant make a bookmark for each idea I can have to vizualize my data. So my question is : can I make make something to :
- first of all, put the "global curve", then select item under 10$ (in the price slicer) and fix this curve also and then select item above 10$ (still in the price slicer) and fix this curve. So at the end I have 3 curves on the same plot
- then, I clear the last 2 curves and select high tech item (in the "category item" slicer) and fix the curve and then select all other items (selecting all boxes in the "category item" except "high tech") and fix this last curve. And I have the second graphic with also 3 curves
Any idea ?
