I’m working on a dashboard using Airtable data and the MAQ Software Calendar Visual in PowerBI. I’ve got it showing one type of event date on a monthly calendar, but I’m stuck trying to add a second event date column. My table looks like this:
| Person | Event A | Event B | Notes |
|--------|---------|---------|-------|
| John | 010122 | 150122 | xyz |
| Sarah | 020122 | 160122 | abc |
| Mike | 030122 | 170122 | def |
Right now, I can only show either Event A or Event B dates for each person. Is there a way to display both event dates for the same person on the calendar? I want to see multiple data points from different columns for each name. Any ideas on how to make this work?
I’ve encountered a similar challenge with the MAQ Software Calendar Visual. One effective approach is to create calculated columns in your dataset. For each person, generate two separate entries—one for Event A and one for Event B. This way, you have a single date column while still being able to distinguish between event types.
By restructuring your table to something like:
Person
Event Type
Date
Notes
John
Event A
010122
xyz
John
Event B
150122
xyz
Sarah
Event A
020122
abc
Sarah
Event B
160122
abc
The calendar visual can then display both event types simultaneously. Using the ‘Event Type’ column for filtering or color coding helps manage the data effectively. Although it requires some data manipulation, this method is a robust solution for showcasing multiple event dates per person.
I’ve wrestled with this exact issue in one of my projects. What ended up working for me was a combination of data restructuring and some DAX magic. First, I created a new table using UNION to combine Event A and Event B into a single date column, like this:
Then, I used this new table as the source for the MAQ Calendar Visual. To differentiate between events, I set up conditional formatting based on the ‘Event’ column. It took some trial and error, but the end result was a clean calendar showing both event types for each person. The bonus is that this method scales well if you need to add more event types in the future.
hey luke, i’ve run into this before. the MAQ calendar visual is kinda limited for multiple date columns. what worked for me was unpivoting the data first to get all dates in one column. then you can use conditional formatting in the visual to differentiate event types. bit of a workaround but gets the job done!