Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
Current data sample - This is data taken from a central source where various users update - i have it then synced to update each month within Power Bi to create an overall dashboard. I need the fix to automatically transform the data to create a chart similar to the below so the months are at the base.
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |