Forum Discussion
Can´t sync graph with matrix
Hi,
I have to tables:
- One table of fact where primary key is a column Id, and amongs columns there is one called "Cartera"
- Another table of measure with a column type Date and other is a Income Plan for each date, this table is related to fact table with Id column.
- I've created a measure called Mensual to calculate the sum of column (Income Plan)
When I tried to use a Line chart to show the Income Plan for each date, I can't make it work interactions beetwen a Matrix and Line Chart, no matter what item I've choosen from Matrix I always see the same line chart thats equals of total of Income Plan
Can you help me to sync line chart and matrix
Greetings
4 Replies
Hi GustavoV1 ,
Please follow this documentation to resolve your issue:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
If your problem is solved then accept this reply as a solution
Thank you
Ajinkya
Ajinka
Thanks by advice, but it does not solution my issue
Hi GustavoV1 ,
There are a few things you can check here:
1. Make sure both your tables are properly connected and hence a proper relationship exists between both tables
2. Make sure interaction between the matrix and line chart is on; validate this from edit interactions
3. Take 2 simple grids(1 with fields in matri, 2nd with fields in line chart) and try filtering them. This will ensure if driving is happening or not
It will be better if you can attach the pbix file or at least attach images of both tables for visual presentation so that community can help you better.
