Pie Charts not acting as filter

[kinseld5]

hi,

trying to understand why pie charts are not acting as filters, is this a limitation in the visualisation? so for example if i set up a dashboard like below, when i select PM 'a' from the chiclet slicer the 'cost' information will change in the pie chart, but it doesnt work the other way, i.e. if i select 0 in the 'cost' pie chart it doesnt update the other two chiclet slicers.

[Caesarul]

Anyone found the solution for this? I have the same issue, but the solution presented is outdated. 

[v-yuezhe-msft · Accepted solution]

@kinseld5,

Click on the pie chart, under Format ribbon, turn on “Edit interactions”, then select “Filter” for the two chiclet slicers. This way, when you select 0 in pie chart, the two chiclet slicers will be updated.

Regards,
Lydia

[kinseld5]

thank you chotu27 and v-yuezhe-msft for your responses, v-yuezhe-msft

v-yuezhe-msftyou proposed option worked well and was easy to implement 🙂 appreciate both of your help

regards,

dave

[chotu27]

@kinseld5

Are all the columns in the same table?

[kinseld5]

thanks for the reply. yes all in the same table.

the table i am using is stored in the below link.

https://drive.google.com/open?id=0BwQtIYqCEeRPdlFZTEdDVnU1NEE

[chotu27]

@kinseld5

 1.  Create a measure as

           Count of cost = COUNT('testpie'[Cost])

2. take pie chart and keep and keepCost column in Details and count of cost in values

3. now select a PM in a slicer it is working

[chotu27]

@kinseld5  Did it work???