Forum Discussion
How to Visualize Table Occupancy Without Synoptic Panel in Power BI?
I’m creating a Power BI report for our upcoming Staff Conference event. The goal is to display the seating plan and indicate which tables are free and which are occupied.
I have the floor plan layout, but I don’t need to use it as a background image. Instead, I’d like to represent each table as a bubble or circle and apply color coding based on seat bookings (e.g., green for available, red for occupied).
I know Synoptic Panel is a great solution for this, but since it’s a paid option, I’m looking for a free alternative within Power BI. Excel supports bubble charts, but Power BI doesn’t have a direct equivalent. I considered using a scatter chart for this purpose, but I’m unsure how to implement it effectively.
Has anyone tried a similar approach or can suggest the best way to achieve this in Power BI without using paid visuals?Seating Plan
Hi VivekN
As an alternative to displaying the table number directly on the scatter markers, you may want to enhance the use of tooltips to improve usability. By configuring a rich tooltip, you can display key details such as the table number, total seats, occupied seats, available seats, and even a status indicator when users hover over a marker. This approach keeps the visual clean while still allowing users to quickly identify and understand each table without needing to click on it, making it a practical workaround given the limitations of the native scatter chart.
Create report tooltip pages in Power BI - Power BI | Microsoft LearnIf I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thanks.
7 Replies
VivekN You could use a scatter chart with a simple table that listed the table number, x and y coordinates and whether the table was full, empty or partially full. Maybe instead have number of seats available total and number of seats filled. Then you could create a measure that you use for conditionally formatting the colors.
Hi VivekN
Thank you for reaching out to the Microsoft Fabric Forum Community.
kushanNa GeraldGEmerick Thanks for the inputs.
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi VivekN
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
- Thank you kushanNa GeraldGEmerick v-priyankata for your input. I have successfully created a seating plan visual using a Scatter Chart. When a marker is selected, it displays details such as Table Number, Total Seats, Occupied Seats, and Available Seats. The chart is plotted using Table Number along with X and Y coordinates. However, I am unable to display the Table Number directly within the circular markers on the scatter plot. My goal is to make the Table Number visible on the markers so users can identify tables without having to click on them. Could you suggest an approach to achieve this?
Hi VivekN
If you need a free solution, you can do this using shape maps. First, you need to convert your image to a supported JSON format and then use the shape map visual. Please read through this article.
Hello VivekN,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
