How do I create a pie plot in a map plot?

[Anonymous]

I have a dataset about some canteens, the number of people per hour, and their total capacities.

The image provided below shows the map. The bigger the bubble, the more people present.

The image below is a screenshot of my table

With regards to the seating capacities, is it possible to show each bubble on the map as a pie chart to represent the fullness of the canteen? For example in the last row, the capacity is 780 and the number of people is 19. So the ratio would be 19/780. 

Or is it possible to plot 2 overlapping different "layers" of bubbles? 1 layer is the current number of people, and the other is the capacity.

Thank you.

[Anonymous]

Hi @Anonymous ,

If you want to show percentage, you can try DIVIDE() function to get result. Also you can try Parameter Field to show the value you want. You can add two measures one is sum by default and another is percentage measure into this function and select the result you want by slicer.

If this reply still couldn't help you solve your issue, please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, thanks for your reply. Sorry, I can't send you a sample file because it's confidential data for my organisation. For my table, I've added 2 new columns: temp and seats_left. You can refer to the screenshot below.

temp = seating_capacity - number_of_people

seats_left = SWITCH(true(), temp < 0, 0, temp) <-- if the number of seats remaining is less than 0, it will be set to 0 instead of being -ve

But basically, for each bubble, I want them to be pie charts that show the ratio of the number of people to the number of remaining seats.

The map and bubbles are the same as before, but for how I want them to look, I want each of them to sorta look like this below (without the detail labels, just the slices).

Of course, each bubble would have a different ratio because different numbers of people go to each canteen.

I hope my explanation helped you get a better understanding of my problem.

Thank you.