Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
KMacd
Regular Visitor

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

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.

3 REPLIES 3
Idrissshatila
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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
Regular Visitor

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.