I’m working with a Power BI dashboard connected to my data source and using MAQ Software’s Calendar Visual to show events in a monthly calendar format. Currently, I can only display one date column at a time, but I need to show multiple date fields from the same record simultaneously.
My data structure looks like this:
| Person |
StartDate |
EndDate |
Notes |
| John |
15/03/24 |
20/03/24 |
xyz |
| Sarah |
10/04/24 |
25/04/24 |
uvw |
| Mike |
05/05/24 |
12/05/24 |
rst |
| Emma |
18/06/24 |
30/06/24 |
opq |
Right now the calendar visual only lets me choose either the StartDate OR EndDate column for each person. I want both date values to appear on the calendar for the same individual. Is it possible to configure this visual to pull from multiple date columns simultaneously so I can see both start and end dates for each person on the same calendar view?
I’ve hit this exact issue before. The MAQ Calendar Visual is super restrictive with multiple date fields per record.
What worked for me: create a union table in Power Query instead of DAX. Go to Transform Data, duplicate your table twice. Remove EndDate from the first copy and StartDate from the second. Rename the remaining date columns to something generic like “EventDate”.
Add a new column called “EventType” with “Start” and “End” values. Then use Append Queries to combine both tables.
This keeps your original table untouched and performs way better than calculated tables. You can easily add conditional formatting in the calendar - start dates in green, end dates in red, whatever works for your dashboard.
Only downside: you’ll need to refresh this union table when source data changes, but that’s standard anyway.
The MAQ Calendar Visual doesn’t handle multiple date columns from the same record well. But here’s a workaround - create a calculated table that unpivots your date columns. Use DAX to reshape your data so each row shows one date event. For example, make a new table where StartDate and EndDate become separate rows with a Type column (start vs end date). This lets the calendar visual show both dates while keeping the connection to the original person record. You’ll probably need to tweak your Notes field to tell start and end events apart, but this should give you what you need without breaking your data.
not exactly sure if maq’s calendar can do that by default, but what you can try is duplicate your rows. like, one for start date, one for end date, and keep your person info same on both. then maybe add a calc column to show start or end. worth a shot!