Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi- I have data presented in a similar format to this:
How can I manipulate this so it appears more like the picture below? (just an example, values are not correct when comparing the 2 charts)
Messed around a bit with it and was unabel to reproduce what I wanted.
I can index it in excel but figured it would be good to know how to do this in Power BI. Any suggestions?
Solved! Go to Solution.
Go to Power Query, select your first three columns and unpivot the others
Go to Power Query, select your first three columns and unpivot the others
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |