Forum Discussion
SharePoint date data to tabular date hierarchy
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!
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
2 Replies
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
