I’m working on a PowerBI dashboard using Airtable data. I’ve set up the MAQ Software Calendar Visual, but I’m hitting a roadblock. Currently, the visual displays either the Event1 or Event2 date for each entry. However, I need it to show both dates simultaneously. Is there a method to achieve this?
My table looks like this:
Person
Event1 Date
Event2 Date
Notes
Alex
01/15/23
02/20/23
xyz
Sam
03/10/23
04/05/23
abc
Does anyone know if the calendar can be configured to accept multiple dates per person from different columns? I’ve explored the available settings but haven’t found a solution. Any assistance would be appreciated!
hey mate, i’ve used this visual before. sadly it doesn’t support multiple dates per entry but here’s a hack: create a new table with duplicate rows, one for each date. then use a relationship to link back to ur main table. it’s not ideal but it works. good luck!
I’ve encountered this limitation with the MAQ Software Calendar Visual as well. While it doesn’t support multiple date columns natively, there’s a potential solution you might consider.
Try creating a custom DAX measure that combines your Event1 and Event2 dates. Something like:
Use this measure in the ‘Event’ field of the calendar visual. It won’t display as separate dates, but it will show both events for each person on their respective days. You may need to adjust the formatting and play with the tooltip settings to optimize the display.
This approach isn’t perfect, but it allows you to see all events without duplicating data or creating complex relationships. Hope this helps with your project!
I’ve actually faced a similar challenge with the MAQ Software Calendar Visual in PowerBI. Unfortunately, it doesn’t natively support displaying multiple date columns simultaneously. However, I found a workaround that might help you.
What I did was create a calculated column in PowerBI that combines both dates into a single string, separated by a delimiter. For example:
Then, I used this new column as the date field in the calendar visual. It’s not perfect, as it shows up as text rather than actual dates, but it allowed me to see both events at once.
For better formatting, you could also create measures to display the event details when hovering over the dates. It takes some extra work, but it gives you the multi-date visibility you’re after without needing to switch to a different visual.
but here’s a hack: create a new table with duplicate rows, one for each date. then use a relationship to link back to ur main table. it’s not ideal but it works. good luck!