SharePoint date data to tabular date hierarchy

[ljkeefe]

Hello,

I have a PBI report receiving data from a SharePoint list that manages our internal meetings. Someone in leadership doesn't like the default view of the Topic name followed by the 3 or 4 meeting dates, like this table: 

Topic	Meeting 1	Meeting 2	Meeting 3	Meeting 4
Topic A	1/1/2025	2/1/2025		2/28/2025
Topic B	3/1/2025	4/1/2025		6/1/2025
Topic C	1/1/2025	2/1/2025		2/28/2025
Topic D	2/1/2025	2/28/2025	3/1/2025	4/1/2025

She wants to see  it by date, meeting, topic, like this: 

Meeting date	Type meeting	Topic
1/1/2025	Meeting 1	Topic A
1/1/2025	Meeting 1	Topic C
2/1/2025	Meeting 1	Topic D
2/1/2025	Meeting 2	Topic A
2/1/2025	Meeting 2	Topic C
2/28/2025	Meeting 4	Topic A
2/28/2025	Meeting 4	Topic C
2/28/2025	Meeting 2	Topic D
3/1/2025	Meeting 1	Topic B
3/1/2025	Meeting 3	Topic D
4/1/2025	Meeting 2	Topic B
4/1/2025	Meeting 4	Topic D
6/1/2025	Meeting 4	Topic B

Is there a way to do this in BI?

Thanks!

[ToddChitt · Accepted solution]

Yes. In Power Query you will want to UNPIVOT the data. In Power Query, highlight the four Meeting columns, then click UNPIVOT and select "Unpivot columns".

If you think you might get additinal columns down the road, select the FIRST column and do "Unpivot Other Columns"

Hope that helps

[ljkeefe]

@ToddChitt That worked. Thanks!