Visual Interactions

[anushaghi123]

I have created 3 views in the data base and importing the same in Power BI to create 3 different bar chart. When I click one any one bar chart it has to reflect other two also but the interaction is not working.

Please help me with this.

[amitchandak · Accepted solution]

@anushaghi123 , Are they connected with each other? If all three are fact/transactional data create common dimension and use them in axis/row/column

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[amitchandak · Accepted solution]

@anushaghi123 , Are they connected with each other? If all three are fact/transactional data create common dimension and use them in axis/row/column

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

[anushaghi123]

Joined the tables to period calendar with many to one relationship.

[v-eqin-msft · Accepted solution]

Hi @anushaghi123 ,

According to your statement, I think your issue should be that the three visuals which are created by related tables are not interacted each other.

I suggest you to follow below steps to check the interactions between these visuals.

Select one visual> Format> Edit interactions

For reference:

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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