Pie Graph not interacting with card

Question

Hi everyone,&nbsp;I received an already worked powerbi Model, I'm not that comfortable with the data base that it's using but i'm trying to make it work, I've searched other posts with no luck since I've seen problems like this one rely more on interactions between graphs or filters, I believe my problem unfortunately might be data configuration.&nbsp;Problem is that when I select one piece of my pie chart my card doesn't interact&nbsp;Data base example&nbsp;MonthGeneral Aviation PassengersComercial PassengersJanuary100500February200300....................&nbsp;&nbsp;&nbsp;&nbsp;I've tried my pie graph with:a) dragging both columnsb) creating 2 measures&nbsp;I've tried my card with:a) A measure by adding the 2 measuresb) A measure by using SUMX with both columns&nbsp;Still haven't found a way to make it work with this combinations.Interactions are working properly since I can choose a month and it interacts perfectly problem relies only between pie chart and card.&nbsp;&nbsp;If you have any ideas i would appreciate it, thank you!&nbsp;

theoc · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
There can be a few reasons for this but if you received the model as is, then just check that:
1. Your pie graph data is from the same table as the KPI card.&nbsp; If this doesn't work, go to 2.
2. Click on your pie graph, then go into the ribbon and go to Format tab. The first button on the left in the Format tab is the "Edit Interactions" button.&nbsp; Please click this.&nbsp; Once clicked, look at the Cark visual to see whether there is a no filter sign.&nbsp; If it is on no filter (the blue circled one), then click the "filter" icon on the card visual (one of the others) so that there is an interaction between the two.

&nbsp;
Hope this helps!
Theo
&nbsp;

vahiddm · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Can you share the measures that you used to set up the card? Did you use any All, removefilters,.... dax formulas in those measures to ignore the filter by PAX names?
Appreciate your Kudos!!&nbsp;

LinkedIn | Twitter | Blog&nbsp;| YouTube&nbsp;

anonymous · Answer

Hi Vahid!&nbsp;Measures I've tried different options for the measures of the card:&nbsp;Opt 1.&nbsp; SUM X of the 2 columns"Pax Totales = SUMX('Indicadores AIT','Indicadores AIT'[PAX AV COMERCIAL] + 'Indicadores AIT'[PAX AV GENERAL])"&nbsp;Opt. 2 the sum of two measures (which are the ones that I use for the PIE GRAPH)&nbsp;Pie Graph Measure 1 (Sum of column 1) =&nbsp;Pax general = SUM('Indicadores AIT'[PAX AV GENERAL])&nbsp;Pie Graph Measure 2 (Sum of column 2)=Pax comercial = SUM('Indicadores AIT'[PAX AV COMERCIAL])&nbsp;Therefore mi card measure would be Measure 1 + measure 2&nbsp;Note: I have also tried to make the pie graph only dragging column values instead of the measures

anonymous · Answer

Thanks for the&nbsp; support TheoC,&nbsp;Yup I only have one data table, and I created one for time functions.&nbsp;I tried interactions proposal with no luck, unfortunately I believe I'll have to live with no interaction or modify data base to have only one column with both passenger types.&nbsp;&nbsp;

theoc · Answer

Hi Anonymous&nbsp;did you click on the KPI card to see if edit interaction was reversed?

Forum Discussion

Pie Graph not interacting with card

9 Replies

Related content

Slicer not interacting with graph

Problem with graph interactions

Fabric graph

Filter Interaction

Creating Cumulative Graphs

Month	General Aviation Passengers	Comercial Passengers
January	100	500
February	200	300
...	...	...
....	....	...