Can´t sync graph with matrix

[GustavoV1]

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

[Icey]

Hi @GustavoV1 ,

Is this problem solved?

Best Regards,

Icey

[Anand24]

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.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Ajinkya369]

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

[GustavoV1]

Ajinka

Thanks by advice, but it does not solution my issue