Forum Discussion
Anonymous
8 years agoNot applicable
create multiple lines in a chart based on products while selecting the product category slicer
Hi Team,
Please note the follwing data,
| ProdCategory | Product | Quantity |
| A | a1 | 140 |
| A | a2 | 150 |
| A | a1 | 210 |
| A | a2 | 150 |
| A | a1 | 65 |
| A | a3 | 78 |
| B | b1 | 150 |
| B | b2 | 25 |
| B | b2 | 25 |
I have to create a chart based on the similar data.Product Category will be keep as a slicer and while selecting it need to show the line chart with average quantity.The challenge is,it has to create the lines dynamically,That is if i select Product category 'A' need to show three line chart.(a1,a2,a3) or i select 'B' need to show two line charts.
Can some one advise me.
Thank you.
Use Product in your Legend
2 Replies
- Greg_DecklerCommunity Champion
Use Product in your Legend
- AnonymousNot applicable
Thanks