Forum Discussion
Solved
Power BI Help Format
I am trying to use an existing excel sheet with columns in Months but I want the power bi to use the months as the x axis and each measure as the Y
In the Power Query editor, select your first 4 columns and then under Transform > Unpivot other columns
This will give you month column that you can use on your x-axis.
In the Power Query editor, select your first 4 columns and then under Transform > Unpivot other columns
This will give you month column that you can use on your x-axis.