Forum Discussion
Pie chart issue
Hello, i just made a pie chart with a column (there are only numbers 1 and 2). Now i have done a filter with people, and want to display in the pie chart how many "1" and how many "2" there are in the rows.
My problem is that the pie chart shows the count of "1" and "2" of a person, but shows it in relation to the max. amount of counts of all people. So the pie chart is not filled when i select a person. Its very small and the rest of the pie chart (the maximum) gets a little transparent. I only want to display the amount of "1" and "2" of one person, and not in relation to the maximum amount.
Then there is for example 20% of the pie chart "1" and 80% "2".
This is how it looks with the relation to the maximum of amount. I dont want that, i need a full filled pie chart for every person which shows the amount of "1" and "2" the person got.
Thanks!
Hi Anonymous ,
Are you using a slicer to filter the pie-chart?
If yes then what you can do is modify the interactions of the slicer for this piechart visual. Follow these steps:
- First thing is make sure you have the latest power BI version at your end.
- Click on your PEOPLE slicer and then on the top bar navigate to Edit Interactions as shown below:
- One you click on Edit Interaction you will have a view as follows for your piechart:
Make sure the highlited Filter icon is selected.
Once this is done whenever you make a selection from your slicer, it will show you the whole piechart with proportions on it.
Let me know if this is what you are looking for.
Thanks,
Pragati
2 Replies
Hi Anonymous ,
Are you using a slicer to filter the pie-chart?
If yes then what you can do is modify the interactions of the slicer for this piechart visual. Follow these steps:
- First thing is make sure you have the latest power BI version at your end.
- Click on your PEOPLE slicer and then on the top bar navigate to Edit Interactions as shown below:
- One you click on Edit Interaction you will have a view as follows for your piechart:
Make sure the highlited Filter icon is selected.
Once this is done whenever you make a selection from your slicer, it will show you the whole piechart with proportions on it.
Let me know if this is what you are looking for.
Thanks,
Pragati