Pie Charts Not Interacting :-(

Question

Hello!&nbsp;I am a novice and I know enough to be dangerous.&nbsp;I have 4 Pie Charts that are not interacting properly. I am trying to troubleshoot potential causes but I am lost.&nbsp;My desired outcome is that selecting any item on any one of the pies changes the other three pies. For example,if I select an Industry I will see the figures based on that Industry in Annual Spend, Spend on Our Brand, and the % Respondents pies. Instead, selecting any pie slice of Industry, Annual Spend, or Brand Spend greys the other three Pie Charts out. The only one that interacts with the other three Pie Charts is Source.&nbsp;Thanks in advance for any tips or tricks I've missed.&nbsp;&nbsp;&nbsp;&nbsp;

jdbuchanan71 · Answer

It is going to be driven by the relationships in the data model and how the measures are written.&nbsp; Selecting "Metal Fabrication" is filtering out all of the rows from the tables that popluate the Annual Spend and % on Our Brand charts.&nbsp; Would it be possible for you to share your model so we can see the data / relationships / measures?

jdbuchanan71 · Answer

The default behavior is to highlight between charts, we just need to change it to filter.

Select one of your pie charts
Click on Format
Edit Interations
Change the interaction from Hightlight to Filter.
- You will have to change the interation between all the charts.
- Chart 1 to charts 2, 3 & 4
- Chart 2 to charts 1, 3 & 4
- etc.

After that, when you select a slice of one all the others will get filtered to your selection.

Default is highlight

After changing interaction to filter

anonymous · Answer

Thank you! That was helpful and moved me closer to a solution. I now experience the following behavior within my charts:

If I select and slice from % respondents the other three pie charts properly show filtered results (yay!)

If I select and slice from Industy, Annual Spend, or Spend on Our Brand, % Respondents properly filters. However the other two pie charts dissapear. So, something is amiss with the way those pie charts are setup.

anonymous · Answer

Sent via message. TY!

jdbuchanan71 · Answer

Hello&nbsp;Anonymous&nbsp;,So what is happening is driven by the way the [Survey Repsonses] is organized.&nbsp; When you pick "Metal Fabrication" as the answer to question 1, what you have really done is applied a filter to the [Survey Repsonses] table ofQuestionKey = 1AnswerKey = 37That filter flows to the other visuals like Annual Spend (Answer key 23) and returns blank because there is no row that has an answer key of both 1 and 23.Because of the structure of the data, with single questions having multiple responses, the only think I can think to do is split the reposonses into a table for each question then link those back to the people table.&nbsp; That way, when you applied the filter.QuestionKey = 1AnswerKey = 37That would flow from your question 1 table to the people table then from there to the other reponse tables but the only way I could get that to work is by setting the relationships as bi-directional which is not a good idea.&nbsp; Here is the DAX code for the first table01. Industry = 
VAR QuestionKey = 1
RETURN
    CALCULATETABLE(
        SUMMARIZE(
            SurveyResponses,
            SurveyResponses[ResponderKey],
            SurveyResponses[QuestionKey],
            SurveyResponses[AnswerKey],
            AnswerLookup[Response]
        )
        ,SurveyResponses[QuestionKey] = QuestionKey
    )I created tables for the three questions in your visual to get it working the way you wanted.&nbsp; The tab [Duplicate of Insights] is my copy with the cross filtering tables used.&nbsp; I sent you an PM with a link to my updated file but you should consider sharing your model with the rest of the community.&nbsp; I am almost certain there is a better way to accomplish what you are trying to do, I just can't get it to work.&nbsp;

Forum Discussion

Pie Charts Not Interacting :-(

6 Replies

Related content

Interactive Pie Chart - Based on Metrics

Pie Chart Question

Pie Chart - Area Interaction

Interaction between line chart and pie chart

Exploded pie chart (pie of a pie)