Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |