I am new to Power BI. I wanted to make a pie chart with the number of occurrences of A, B, C, A&C, B&C etc in the last column of the following table.
For example, the number of times A is present in the last column is 34 and B is 68 and so on. I want to create a pie chart depicting this data. Can someone help me with this?
Go to Solution.
If B is within B&C should be counted?If not, simply add a pie chart, use any unique column as counter and your B&C/B/A column as category...
I guess this is what you are looking for:
Just drag your last column to the legend property and also to the value property of the Pie chart, as the column has the data type text, Power BI automatically selects the aggregation function Count.
Hopefully this is what you are looking for.
I would be glad to know how to count B&C in B and C separately.
Can you clarify?Should B&C, B and C have THREE different slices in the pie?Or in a case likeB&C ->3B ->4 C ->2
you expect to have TWO slices, one for B (4+3) and one for C (2+3)?
So, if the data is as following:B&C occurs 4 times
B occurs 5 times
C occurs 6 times
Then the count of B should be 9 and C should be 10.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!