Interactive Switch Chart both ways

[israabuhasna]

Hi,

We created a switch table from our main properties table which contains two columns: Type,Group. Table looks like below:

Group	Type
Company A	Client
Company B	Client
x	Product Type
y	Product Type

We then added a bar chart and slicer to be able to toggle from Client to Product type. We have other visuals on the report from the original table. There is no relationship between the switch visual and the rest of the tables as should be. So, when we click on a non-switch visual, the whole page interacts as should and the switch visual also interacts. However, when we click on the switch visual, no other visual interacts. Its like a one way interaction but there are no relationships from switch table to original table. 

Any ideas why and how we can fix it or workaround?

[v-lionel-msft]

Hi @israabuhasna ,

" However, when we click on the switch visual, no other visual interacts. Its like a one way interaction but there are no relationships from switch table to original table. "

What do you want is that other visuals also interact when you click to the switch visual?

It may be because there is no relationship between the tables.

Have you considered establishing a relationship between the tables? 

If you can't create table relationships, you can also use Dax to create columns or measures and add them to the visual.

Also do you mind sharing your pbix file?

Best regards,
Lionel Chen

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

[amitchandak]

This because when you click the value now belongs to this new dimension which is not joined with others. Typically people use bookmarks for this. Having one visual behind another visual

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive