This content has been marked as final. Show 4 replies
I have got a task to create a dashboard. On the sheet there should be a filter of Category, depending on a selection in the Category field, a line chart should show monthly (Dimension) values (Measure) for Sub-Categories in the selected Category as separate lines.
So this considers different number of lines for different category, and I can not include them all by hand because there is a large amount of sub-categories.
Is there a way to create a dynamic line chart that has a feature of filtering the selected values only?