Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Having issues trying to figure this problem I have out. I have a big dataset ive imported from excel and within that dataset are the three columns below. I am struggling to list the Maps from all three columns as my axis. What I am after is a clustered column graph with each Map on the axis, and then the number of Bans that map recieved and whether it was the 1st ban, 2nd ban or third ban.
My Data:
Where Im Stuck:
Solved! Go to Solution.
Hey OceanMan,
you need to unpivot the table in the PowerQuery Editor.
I did that for you in that example file
Here you have a Screen.Gif -> Sorry for the german version but you will get it 🙂
Please kudo & mark this post if I was able to help you
Have a nice day OceanMan!
BR,
Josef
You will need to unpivot the columns so you can use them as x axis on your chart
Hey OceanMan,
you need to unpivot the table in the PowerQuery Editor.
I did that for you in that example file
Here you have a Screen.Gif -> Sorry for the german version but you will get it 🙂
Please kudo & mark this post if I was able to help you
Have a nice day OceanMan!
BR,
Josef
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |