Using Airtable data in PowerBI with the MAQ Calendar Visual, can we display both event dates simultaneously? My dataset has columns for Event1 and Event2 dates.
hey, i’ve used MAQ Calendar before. it’s not great for multiple dates, but there’s a workaround. try restructuring your airtable data first. make one ‘EventDate’ column and an ‘EventType’ column instead of separate event columns. each event gets its own row. use Power Query to do this. then the calendar should work. might need some fiddling with settings tho. good luck!
I’ve worked with MAQ Software’s Calendar Visual in PowerBI, and while it’s great for single date events, displaying multiple dates can be tricky. In my experience, the best approach is to restructure your Airtable data before importing it into PowerBI. Instead of separate columns for Event1 and Event2 dates, create a single ‘EventDate’ column and an ‘EventType’ column. This way, each event gets its own row. You can use Power Query to transform the data easily. Once done, the MAQ Calendar should be able to display all events. It might take some tweaking in the visual’s settings, but it’s definitely doable. If you’re still stuck, MAQ’s support team is surprisingly responsive and might have additional tips.
I’ve dealt with similar issues using MAQ Software’s Calendar Visual in PowerBI. While it’s not designed explicitly for multiple dates per event, there’s a workaround that’s worked well for me.
The key is to restructure your Airtable data before importing it into PowerBI. Instead of separate columns for Event1 and Event2 dates, create a single ‘EventDate’ column and an ‘EventType’ column. This way, each event date gets its own row.
You can use Power Query to transform the data. It’s a bit time-consuming initially, but it makes the visualization much smoother. Once you’ve done this, the MAQ Calendar should display all your events without a hitch.
One thing to keep in mind: you might need to play around with the visual’s settings to get it looking just right. Don’t be afraid to experiment with different configurations.
If you’re still having trouble after trying this approach, I’d recommend reaching out to MAQ’s support team. They’ve been quite helpful in my experience and might have some additional tips or workarounds specific to your use case.