Forum Discussion
Visual Interactions - pie chart not working properly
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.
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.
sorry, I may have simplified the dummy data in a wrong way lol
The data is like
- NAME
- COUNTRY
- YES/NO
- AGE GROUP (IF YES, age group is provided. If NO, age group is blank)
When I click on "blank" in piechart AgeGroup,The data just highlighted the NO but not turning YES to zero.
When I click on the other age group, it turns like this
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!
