Cross filtering stops working if I add more than 1 value to visuals

[KMacd]

I have a line chart and a pie chart, both off the same tables data, that stop cross hilighing/cross filtering all other visuals if I add more then one value.  I have checked edit interactions and both visuals are interacting with all other visuals.  If I remove all but one value they cross filtere/hilight correctly.

I would appricaite any suggestions on what to do to get them working, thanks.

[Idrissshatila]

Hello @KMacd ,

you need to make sure that there's a relationship between the values in these charts and the values in the other charts.

and honestly it all depends on your data model how it's done.

i suggest you build it as a star schema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

[KMacd]

There is only one table.  Both visuals use the same values from that table.  The line chart is the number of each value per month and the pie chart is the persentage of the total.  The are 10 actions that the team does and both visuals are showing the same ten actions.

[KMacd]

Update: The line chart will filter on the x-axis but on on the Y-axis