I’m working with a Power BI dashboard connected to my data source and using the MAQ Software Calendar Visual. Currently I can display events from one date column on the calendar view, but I need to show events from multiple date columns for the same records.
My data structure looks like this:
Person
StartDate
EndDate
Notes
John
15/03/24
20/03/24
meeting
Sarah
10/04/24
12/04/24
training
Mike
25/02/24
28/02/24
workshop
Right now the calendar visual only lets me pick either StartDate OR EndDate as the source. I want both dates to appear on the same calendar for each person. Is there a way to configure this visual to pull from multiple date columns simultaneously? I need each record to generate multiple calendar entries based on different date fields.
I’ve faced the same issue with the MAQ calendar visual previously. It’s quite limiting since it can only bind to a single date field. To resolve this, I created a union table in DAX which duplicates the records for each date. You can use a formula like: UNION(SELECTCOLUMNS(YourTable, “Person”, [Person], “Date”, [StartDate], “EventType”, “Start”, “Notes”, [Notes]), SELECTCOLUMNS(YourTable, “Person”, [Person], “Date”, [EndDate], “EventType”, “End”, “Notes”, [Notes])). This way, each original record generates two entries—one for the start date and another for the end date. Just set the MAQ visual to use the new table’s Date column, and you’ll have both dates displayed on the calendar.
Been dealing with this exact scenario for years. The MAQ visual is pretty rigid about single date columns.
I usually create a staging table that transforms your data structure. Instead of separate StartDate and EndDate columns, reshape it so each row represents one date event.
So your John record becomes two rows:
John | 15/03/24 | Start | meeting
John | 20/03/24 | End | meeting
I handle this in Power Query with a custom column that duplicates each row, then merge the date columns into one. Takes about 10 minutes to set up and works every time.
The key is adding that event type indicator so you can still distinguish between start and end dates on the calendar. You can even color code them differently in the visual settings.
This approach also makes it easier if you need to add more date types later like “reminder date” or “follow up date.”
you gotta unpivot those date columns first, try using Power Query or make a calculated table to get startdate & enddate into separate rows with a type column. then the MAQ calendar visual can show all the dates from a single column, no problem.