Forum Discussion

anushaghi123's avatar
anushaghi123
Helper II
3 years ago
Solved

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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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-8e3eccb41bda

 

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

  • anushaghi123's avatar
    anushaghi123
    Helper II
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.