Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to filter stacked column chart only based on axis selected

 I'm trying to achieve this:

User uses this stack column chart as a filter, no matter which part of the bar user clicks, it only filter other visuals by its axis legend.

 

For example: when user click Alpine(S) bar part, it won't be filtering ERP groups but only axis(this case is Alpine(S)).

 

Thanks

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , In case of drill-down and tooltip page. we have the option to control the column we want to pass. We can uncheck the keep all filter and only drag what we want in "Add drill through/tooltip filter here"

     

    Same is not possible with drill down/across. You need to create a measure in other visual which do not take legend values

     

    calculate([Sales], removefilters(Table[Legend Column]))