Forum Discussion

nok0620's avatar
nok0620
Frequent Visitor
8 years ago
Solved

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...
  • GeorgeBuster's avatar
    GeorgeBuster
    8 years ago

    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.

GeorgeBuster's avatar
GeorgeBuster
Advocate III
8 years ago

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.

rsree's avatar
rsree
Regular Visitor
4 years ago

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!