Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

create multiple lines in a chart based on products while selecting the product category slicer

Hi Team,

 

Please note the follwing data,

ProdCategoryProductQuantity
Aa1140
Aa2150
Aa1210
Aa2150
Aa165
Aa378
Bb1150
Bb225
Bb225

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.