I’m working on a PowerBI dashboard using Airtable data. I’ve got this cool Calendar Visual by MAQ Software. It’s great for showing one type of event date on a monthly view. But now I’m stuck.
My table looks like this:
| Person | Date1 | Date2 | Notes |
|--------|---------|---------|-------|
| John | 010123 | 150123 | xyz |
| Sarah | 020123 | 160123 | abc |
| Mike | 030123 | 170123 | def |
Right now, I can show either Date1 or Date2 for each person. But I really want to show both dates for the same person on the calendar. Is there a way to do this? Can the visual take both date columns as input?
I’ve tried looking through the options, but can’t find anything. Any ideas on how to make this work? It would be super helpful to see all the events at once!
I’ve faced a similar challenge with the MAQ Software Calendar Visual. Unfortunately, it doesn’t support multiple date columns natively. However, here’s a workaround I’ve used:
Create a calculated table in Power BI that unpivots your date columns. This essentially doubles your rows, with each person having two entries - one for Date1 and one for Date2. You can add a column to distinguish between the date types.
Use this new table as the source for your calendar visual. This way, both dates will appear for each person. It’s not perfect, but it gets the job done. For more complex scenarios, consider custom visuals or even developing your own. In most cases, the unpivot method should suffice.
hey, i’ve dealt with this before. the maq calendar is cool but kinda limited. here’s a trick: make a new table in powerbi that duplicates each row, one for date1 and one for date2. then use that for ur calendar. it’s not perfect but it works. good luck!
I’ve grappled with this exact issue in my projects. While the MAQ Calendar Visual is fantastic, it does have limitations with multiple date fields. Here’s what worked for me:
I created a calculated column in my original table called ‘Combined Dates’. It merged Date1 and Date2 into a single text string, separated by a delimiter. Then, I used DAX to split this column back into individual date values in a new calculated table.
This approach allowed me to maintain my original data structure while still displaying both dates on the calendar. It took some trial and error, but the result was worth it. The calendar became much more informative, showing the full picture of events for each person.
One caveat: if your dates are far apart, this method might clutter the calendar. In that case, you might need to explore custom visuals or even consider building your own using the Power BI SDK. It’s a bit of a learning curve, but it gives you full control over the visualization.