Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How would I go about having a seperate column for the players position. At the moment you can see I have to use Pos/Name together to see my position. Matrix wont allow me to do this, I dont like the dropdown option either.
Use Power BI Split option to separate the both
Use the delimiter "/"
https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
Regards,
Ritesh
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
Sorry Ribisht17, but maybe I didn't make myself clear as to what I want. I want another column called Position this will show what position the player beside it holds. As I said in my first request Matrix does not allow this. When I include position the system creates drop-down which is what I don't want.
Hi @WheelchairWilly ,
According to your statement, I think you want to add a column beside [Player] in Matrix.
I suggest you to turn off "Stepped layout" function in visual format and then drill down all level to get result.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |