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.
You can do this pretty easily in Power BI, can you post some screenshots or provide some sample data? It's tough to understand the problem you're having right now.