Forum Discussion

ammartino44's avatar
ammartino44
Icon for Helper III rankHelper III
9 years ago

3 different stacked bar chart

Hello. I have three different stacked bar charts. For three years of data and they include states. At the bottom is a table with all three years as well as the states. Is it possible that when I click on a state in just ONE year that it would select the states in all the years? Right now it just selects that state and that specific year. 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi ammartino44,

    Could you please post screenshots about your scenario? Do you want to click data section in stacked bar chart to filter data in all years in table visual? If that is the case, you would need to create a state slicer.

    However, if you want to click single value in state slicer and year slicer to filter data in all years in table visual, you would need to create measure as other’s post, please help to post sample data of your tables so that we can provide you appropriate DAX formula.

    Thanks,
    Lydia Zhang