Clustered column chart - click only one bar

[Anonymous]

Hi,

I have these two database

1. TotalStackID)_table

2. NewStackID_table

I put them in a culstered column chart as shown

 

I also created a table that contains the name of each stackID filtered by country

My question is,

is it possible if I click only the New StackID bar (light blue) on 31/10 and the table will display the data from NewStackID_table on 31/10? 

and vice versa, when I click on Total StackID bar (dark blue) on 31/10, the table will display the data TotalStackID_table.

Thankyou in advance

[v-yuta-msft · Accepted solution]

@Anonymous ,

If you need to use Bar chart to filter other chart/represent the filtered chart. You should use "Drillthrough", this will filter the chart in another page. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

However, in you need to filter the same visual in the same page, I would suggest you use slicer instead of bar chart.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Yes, I've tried to use the slicer and it works well. It's not what I wanted but it enough for now.

.

Thank you.