Need more than one side column

[WheelchairWilly]

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.

[ribisht17]

@WheelchairWilly 

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

[WheelchairWilly]

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.

[v-rzhou-msft]

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.