Forum Discussion

powerbitv's avatar
powerbitv
Frequent Visitor
8 years ago

drill down based on legends

I am creating a stacked area chart with Moths on X-axis and sales on Y axis and product as legends. Now I want to create a  drill down on the charts with Praducts->Category->SubCategory, is it possib...
Need Help
natasharaymond's avatar
natasharaymond
Regular Visitor
6 years ago

Can you walk through how you created this?

DouweMeer's avatar
DouweMeer
Impactful Individual
6 years ago

Like this:

 

 

Then use 'Table 2'[Filter] for the column required in a filter visual. 

  • natasharaymond's avatar
    natasharaymond
    Regular Visitor
    6 years ago

    worked great, thanks

  • DouweMeer's avatar
    DouweMeer
    Impactful Individual
    6 years ago

    Top!

    I'm just missing a real life application for this. The only really useful things I've found is if you want to mess around with the data as a user. 

  • Quentin's avatar
    Quentin
    Helper IV
    5 years ago

    It has great life application
    I am facing the same issue with composite Index evolution over time
    I wanna see evolution of composite index in Y and time in X, but i want to be able to drill down the subcategories of my composite index:
    click on the graph it shows the evolution of the three main categories over time
    click on one main categories it shoes me the evolution of the variable it is composed of (over time in X)
    Value is the same (measure called value who does sort of an average)