Edit Interactions not working

[mhablas426]

Dears,
I have a line and clustered column chart I want to make them interact together when I press drill down reflected in other visuals, I tried the below steps and still not working with me

• Select a Visual: Click on the first visual that you want to use as the interactive filter or driver for the other visual.

• Edit Interactions: Go to the Format tab at the top and select Edit interactions. This will make small icons appear above all the other visuals on the page.

• Choose Interaction Type:

  • Filter icon: If you want the selected visual to filter the other visual, click on the filter icon (funnel shape) above the second visual.

[v-tangjie-msft · Accepted solution]

Hi @mhablas426 ,

Has your problem been solved? If the problem has been solved you can mark the helpful reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

Best Regards,

Neeko Tang

[mhablas426]

Not solved but I used a visual  "line and clusters column chart" instead and works well for me

[mhablas426]

@Uzi2019 @SamWiseOwl 
I have tried to add new pages add both the chart from scratch and start the Power BI desktop with a new file
and still not working 

[Uzi2019]

Hi @mhablas426 

yeah sometimes you may get no option for edit interaction on chart.

try to add new page add both the chart from scratch and check for edit interaction option again.

or incase after adding a new page still you are not able to see the edit interaction option.. closed everything and satrt power bi desktop a new file then try to add both chart and apply some edit interaction.

I hope I answered your question!

[Uzi2019]

Hi @mhablas426 

Please check the videos for better understanding. It might help you to create proper edit interaction with highlight.

https://www.youtube.com/watch?v=MW_VzfNRzxg

https://www.youtube.com/watch?v=-fwjqEWbr1c

https://www.youtube.com/watch?v=ENuG2F-tce0

https://www.youtube.com/watch?v=54pBUbVL8tU

I hope above videos would help you to set edit interaction properly.

I hope I answered your question!

[mhablas426]

Thanks so much

[SamWiseOwl]

Hi @mhablas426 

In your image I don't see the icons for interactions turned on.

They should look like this:

Here I am clicked on the line chart and the Interaction icons are appearing on the column chart.

The left most is filter, middle is highlight and the right most is turned off.

Column charts can only filter Line charts.

When interacting with the line chart drilldown it will always filter the column chart not highlight.

In the above I have drilled down from Year to month.

[mhablas426]

[SamWiseOwl]

Hi @mhablas426 

What isn't happening?

Are you clicking a data point in the column chart and it isn't filtering the line chart?

Or are you drilling in one visual and the other isn't drilling?