PowerBI Calendar Visual by MAQ Software - Multiple Start Date Columns for different events - Airtable Connection
I have connected to a dataset in Airtable to create a dashboard using this data. I have used the Calendar Visual by MAQ Software to create a visual that maps certain date events onto a monthly calendar view. All works well; but now I want to try and use a second column to map different events; however cannot find any options to do so.
Table that I am using has the following format:
| 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 |
Right now I am able to have the visual present a calendar with either Event1 date OR Event2 date for a given name. Is there a way to have it take BOTH event dates as an input? i.e. for the same name have multiple different data points pulling from different columns?
You will need to unpivot your table so that each row has one date. You can do this in Power Query.
Select the two date columns and then Unpivot Columns in the Transform tab. You will get a table structure similar to:
| Name | Comments | Event | Date |
|---|---|---|---|
| Name1 | abc | Event1 | DDMMYY |
| Name1 | abc | Event2 | DDMMYY |
| Name2 | def | Event1 | DDMMYY |
| Name2 | def | Event2 | DDMMYY |
| Name3 | ghi | Event1 | DDMMYY |
| Name3 | ghi | Event2 | DDMMYY |
| Name4 | jkl | Event1 | DDMMYY |
| Name4 | jkl | Event2 | DDMMYY |
| Name5 | mno | Event1 | DDMMYY |
| Name5 | mno | Event2 | DDMMYY |
| Name6 | pqr | Event1 | DDMMYY |
| Name6 | pqr | Event2 | DDMMYY |