Using MAQ Software's PowerBI Calendar Visual with Multiple Event Date Columns from Airtable

Other Questions Airtable
1

I have established a connection to an Airtable dataset for creating a dashboard using this information. So far, I have successfully utilized the Calendar Visual created by MAQ Software to display certain date events in a monthly format. However, I’m now looking to incorporate a second date column to represent different events, but I’m unable to identify how to achieve this.

The structure of my table is as follows:

Name Event1 Date Event2 Date Comments
Name1 DDMMYY DDMMYY abc
Name2 DDMMYY DDMMYY def
Name3 DDMMYY DDMMYY ghi
Name4 DDMMYY DDMMYY jkl
Name5 DDMMYY DDMMYY mno
Name6 DDMMYY DDMMYY pqr

At the moment, the visual only allows me to display either the Event1 or Event2 date for a particular name. Is there a method to include both event dates simultaneously? Essentially, can I pull different data points from both columns for the same entry?

2

I encountered a similar issue while working with multiple date columns in Power BI. One approach you can try is creating a calculated column that unifies both event dates into one column. You can concatenate the events in one column with a delimiter, such as a semicolon or space, between them. Then, in your visuals, you could leverage this new column to display both sets of event dates together. This is a bit of a workaround, but it should allow you to show both events simultaneously. Another thing to consider is using conditional formatting to distinguish different event types, which can make your dashboard more intuitive to read. I found these methods quite effective for my requirements.