Forum Discussion
Synoptic Panel partial results
I have an SVG mapping the seats in an arena. I then have a table that has 1 row per ticket with a unique identifier that is in the same format as each object in the svg. The format is "section-row-seatnumber", for example, "A-10-11" for section A row 10 seat 11.
My unique identifer in my ticket table is called ticket_key. I then have another column called seat_status that is "Unused" for tickets that were not scanned for attendance, or "Scanned" for those that were in attendance. I also have a measure called "SeatStatus" that is essentially the same as the seat_status - but I don't really understand the role of the measure here so if someone can explain that would be great.
I am trying to overlay these tickets to the SVG to show unused tickets in one color, scanned in another, and unpurchased tickets in light gray (unmatched). Below are some photos of how I have this set up.
With this setup, only a portion of my SVG populates as seen in the next pic.
When I change the fields to have ticket_key in "Category" and I remove the subcategory field, I see the following:
I am looking for assistance here in order to:
1. Understand the role of the measure, what I should use here and how to set that up
2. How to assign the category, subcategory and measure properly in order to highlight unused versus scanned tickets, while leaving seats that were not originally purchased as the default light gray.
Thanks in advance!
4 Replies
Hi JoelFrank98
1. Understand the role of the measure, what I should use here and how to set that up
In Power BI, measures are used to perform calculations on data in the model.
For your problem, the measure can be used to dynamically calculate and display the status of each seat based on the column.
2. How to assign the category, subcategory and measure properly in order to highlight unused versus scanned tickets, while leaving seats that were not originally purchased as the default light gray.
The ticket_key should be placed in the “Category” field.
This is used as a unique identifier to link each seat in the SVG to a row in the dataset. In this case, no “subcategory” is needed.
The measure can be used to determine the color of each seat in the Synoptic Panel. For example:
Seat Color = SWITCH(TRUE(), [SeatStatus] = "Scanned", "Green", [SeatStatus] = "Unused", "Red", "LightGray" // Default color for unmatched or unassigned seats )If only a portion of your SVG populates, it could be due to mismatches between the values in your dataset and the IDs in your SVG.
Double-check that these values are correctly formatted and match exactly.
Additionally, ensure that your SVG is correctly structured and that all seat elements are properly identified with unique IDs.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thanks for responding. Still running into some issues. When I use ticket_key in category and then hit "Show All" in the data colors, I see this:
where it gives me the option to change the colour for each individual ticket_key value rather than for those scanned or those unused.
Hi JoelFrank98
Please provide your pbix file to help you resolve the problem. Delete sensitive data.
Anonymous
how can I share the attachment with you? Sorry for the late response, finally coming back to this. I have a pbix file with no sensitive data that I can shareI need an email address to share the file with you as organizational controls are preventing me from giving open access.
