Forum Discussion
question about data display in Pie Chart
Hi guys,
I found that when using pie charts, the data is not displayed according to the slices but is scaled based on the original values. Could you please explain what causes this and how to change it?
Thank you.
Hi Aaron_Z , rajendraongole1, thank you for your prompt reply!
According to your screenshot and description, it is more related to the column where you summarize the close_value, for example, in the bar chart you summarize the close_value based on the sales_agent, however in the pie chart you summarize the value based on the account column.In this case, if the sales_agent is not exactly equal to the account, the pie chart will not be able to show the true portion of the value when we select the specific bar in the bar chart.
Result:Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The solution for this situation is to edit the interations between visuals. For example, to be able to edit interations between visual A and visual B, you have to select A then click Format on the top ribbon, and you will see the Edit Interactions button showing at the left of top ribbon. After enable the edit interactions, you can change the interaction of visual B from visual A, like filt or highlight data in the visual B when you select data in the visual A. Hope this can help someone who confused like me.
3 Replies
Hi Aaron_Z - If the values are not summarized correctly example as per snapshot sum of close value by account in the pie chart might display unexpected results.
Ensure that the values you are using in the pie chart are summarized correctly. By default, Power BI summarizes numerical data (e.g., sums, averages, counts). You can adjust this by clicking the value field and selecting the appropriate summarization method.
Basically, If you have many categories, a pie chart can become cluttered and hard to read. you can try with bar chart or column chart is usually more effective.
Still issue exist, please share some sample data.
hope it helps
Hi Aaron_Z , rajendraongole1, thank you for your prompt reply!
According to your screenshot and description, it is more related to the column where you summarize the close_value, for example, in the bar chart you summarize the close_value based on the sales_agent, however in the pie chart you summarize the value based on the account column.In this case, if the sales_agent is not exactly equal to the account, the pie chart will not be able to show the true portion of the value when we select the specific bar in the bar chart.
Result:Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The solution for this situation is to edit the interations between visuals. For example, to be able to edit interations between visual A and visual B, you have to select A then click Format on the top ribbon, and you will see the Edit Interactions button showing at the left of top ribbon. After enable the edit interactions, you can change the interaction of visual B from visual A, like filt or highlight data in the visual B when you select data in the visual A. Hope this can help someone who confused like me.
