Forum Discussion
Helper IIINeed more than one side column
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.
3 Replies
- ribisht17
Super User
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
WheelchairWillySorry 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
