Forum Discussion
Advice on formatting data
I have the below excel to keep track of dates of maintenance.
Wondering how best to format this data in excel in order to put it into PowerBi so that I can put it in a similar format in PowerBi
esims123
You will have to unpivot your data to create sort of a smiliar visualization in Power BI using the Matrix viz.
Watch this viedeo on how to unpivot columns with multiple/merged headers: (111) How to Unpivot Multi Header Data in Power Query | Part-02 (Super Easy) - YouTube
1 Reply
esims123
You will have to unpivot your data to create sort of a smiliar visualization in Power BI using the Matrix viz.
Watch this viedeo on how to unpivot columns with multiple/merged headers: (111) How to Unpivot Multi Header Data in Power Query | Part-02 (Super Easy) - YouTube