Forum Discussion
Visual Interactions
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.
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-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Joined the tables to period calendar with many to one relationship.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
