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.
Question:
Is there a way to create a dynamic line chart that has a feature of filtering the selected values only?
I downloaded and added the extension, I am able to add the options list, but in the end i only see one single line of filtered values. Instead, i need to see multiple lines as subcategories related to selected category.
