Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
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?
Solved! 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...
Hey,
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.
Regards,
Tom
Hey,
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.
Regards,
Tom
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 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 like
B&C ->3
B ->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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |