Power BI: interaction between charts (filtering between each others)

This article is to explain how 2 charts like bar charts can filter between them. For instance, by selectin an option in the chart 1, the chart 2 will only display related results:

power bi
power bi

There are 2 ways to do it, via the Power Bi Desktop or the Power BI Service by using the “edit interaction” option. For Power BI Desktop:

  • 1. Select the chart 1
  • 2. Click on format -> edit interactions
    power bi
  • 3. In the chart 2, at the top right, select “filter”
    power bi

If I want the chart 1 to behave the same way as the chart 2, I will select the chart 2 and on the chart 1, select “filter”. Once done, just save, publish and update the app so the audience can play with it.

For Power BI Service, it is the same thing except that to find the “edit interactions” option:

  • 1. Open the report
    power bi
  • 2. Click on “edit”
    power bi
  • 3. Click on “visual interactions” -> turn on “edit interactions”
    power bi
  • 4. Select the chart 1 and on the chart 2, select “filter”
    power bi

Once done, save and update the app.

Interesting Topics