Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I have data that comes over in one column, but I need to make it show up in one row. Below is how it comes over and what I need. I used to pretty strong BI, but I've been out of it for a while and gotten a bit rusty on stuff like this; I think I need to do a custom table.
The below is how my raw data comes over.
Below is what I need it to come over as or at least what I need a table visual to look like.
I tried making my own column that just filters on each rank (I kinda knew that wouldn't work), and below is what I get.
Thank you for all your help.
Solved! Go to Solution.
Hi @bcampbell2 ,
I'd suggest to do some pivoting in Power Query:
Open Power Query, mark the Rank column, click on Pivot column (under transform) and adapt the settings accordingly:
Does this solve the issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @bcampbell2 ,
I'd suggest to do some pivoting in Power Query:
Open Power Query, mark the Rank column, click on Pivot column (under transform) and adapt the settings accordingly:
Does this solve the issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |