Forum Discussion
Visual Interactions - pie chart not working properly
There're two piecharts on my dashboard. When I click on one of the areas of piechart A (by country), piechart B (only YES or NO) should highlight and flag out values regarding that particular area of piechart A. However, piechart B fails to reflect to real numbers.
i.e.
Piechart A
HK 30 (2 YES, 28 NO)
SG 20 (11 YES, 9 NO)
JP 50 (30 YES, 20 NO)
AU 15 (all YES)
Piechart B
YES 58
NO 57
Piechart still shows NO with (57) when I click on AU, it should be zero.
Any idea why this happens ? Thanks.
This is really weird. Let's do some tests.
1. Use this measure instead of the automatic count:
CountMeaseure=
var Number=DISTINCTCOUNT(Name)
return
IF(
Number=BLANK();
0;
Number
)2. Tell me if the mouseover value is right.
3. Try with the differents Label styles.
15 Replies
Hi Nok0620,
The first cause might be that the piecharts are not connected by the "Edit Interactions" tool of Power BI Desktop.
1. Select the piechart A.
2. Click in the top Menu: Format>Edit Iteractions.
3. Test the icons on the piechart B are ON (you can select filter o highlight).
The second option might be that your tables, which join the data of country and YES/NO, have an incorrect relationship. Test that the fields that join those tables are right and also that the direction of the relationship allows filter as you want.
Best,
Jorge Bustillo.
I've tried to re-do the "Edit Interactions", piechart A and B are actually from the same table.
From the screen-cap you can see the YES/NO chart after highlighting area in piechart A.
The numbers in YES did change, NO should be 0 but it remains as the old number.
Thanks for the help though :smileytongue:
Well, see what I've developed and find what differences you could have. Otherwise, tell us more about your table and we try to help you.
Best,
Jorge Bustillo.
I'm a beginner and was very confused why my piechart A was filtering but not my piechart B. You saved my day. Thanks a lot!
