Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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
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.
Update: The line chart will filter on the x-axis but on on the Y-axis
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
179 | |
86 | |
69 | |
63 | |
55 |