Forum Discussion
buck1327
1 year agoFrequent Visitor
Line chart with selected customers only
I have a line chart which show the sales of customers (over 1K). I have multiple slicers such as year, month, region etc, and one of slicer is customers which I can select a few customers (e.g. custo...
- 1 year ago
Hi,
See if my solution in the attached file helps.
- 1 year ago
Yes. To answer your question "where is the "total sales all customer" created?" that's up for you know, what goes there is the column or sum measure you are using to represent the numerical values. You won't need to include any selected customers in the formula, by using your filters and slicers, your measure will consider those as part of the row context.
Ashish_Mathur
1 year agoSuper User
Hi,
See if my solution in the attached file helps.
- buck13271 year agoFrequent Visitor
Thank you Ashish_Mathur . Wonderful demo
- Ashish_Mathur1 year agoSuper User
Thank you.