What are the best ways to analyze data where months are given as columns in Power BI?

What are the different ways to transform data where months are given as columns in Power BI?

When your data is months keyed rather than rowed, it’s what is commonly termed a “wide” format. An example of how data in this format can present difficulty is illustrated below. To work with this kind of data, you will have to use the Unpivot Columns feature. It helps in converting a table that is columnar into its row-based version. The following are the steps to do so:

1. Under the Home tab, click Transform Data to open the Power Query Editor.
2. Select the table that contains the data you wish to unpivot.
3. While you can select specific columns to unpivot, it’s generally more efficient to select the column you do not want to unpivot.
4. In the Transform tab, within the Any Column group, click the small downward arrow next to Unpivot Columns.
5. Choose Unpivot Other Columns.