stacked bar chart shows only highlighted values

[Dunner2020]

Hi there,

I have a measure that calculates no of events linked to the areas. Measure is:

No of Events =

CALCULATE(

            COUNTX(FILTER('Table 1',

                'Table 1'[Date]<=TODAY()),  

                'Table 1'[Event ID]))

I created a stacked bar chart which shows no of events each area has. I created another stacked bar chart which shows the breakdown of events within each area zone. For example if area 'AB' has 10 events, then the second stacked bar chart shows the breakdown for example AB1 has 5 events, AB4 has 2 so on and so forth (in the Second stacked bar chart I used the same measure for displaying values, I only changed the axis values )

When I click on the area bar of the first stacked bar chart, the second stacked bar chart highlights the sub-areas of the selected area bar as shown in the figure:

However, I want to show only highlighted subareas in the second stacked bar chart. I don't want to see the remaining 'un-highlighted' bars in the second bar chart. Is there any way of doing that in Power BI?

[amitchandak · Accepted solution]

@Dunner2020 , Change interaction, use cross filter

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions