How to display a pivot table with text values?

[jdubs]

I want to display a very simple pivot table with collapsible rows. All the search results I've found suggest using the Matrix visual, however when I use this, it does not produce the results I'm looking for.

Basically I want to display a list of Accounts and their associated Orders below. Is this possible?

A crude example:

Account A

     Order 1

     Order 2

     Order 3

Account B

     Order 1

     Order 2

etc......

[amitchandak]

@jdubs , this does not seem like what is missing in the matrix. Can you share a better example?

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[jdubs]

My bad. I am using a value for Orders which is repeating, therefore it only produces one sub-row. If I change it to a unique identifier it gives me multiple rows. Now I just need to display a meaningful name instead of the UID. 

Additionally, is there a way to add sub-columns to these rows? 

e.g.

Account 1

     Order Status     Order Number     Delivery Status

[parry2k · Accepted solution]

@jdubs you can add as many columns as you want, on format pane, you can change the stepped layout on or off to create the look you want.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[jdubs]

Brilliant. Thanks guys!

[parry2k]

@jdubs yes on matrix visual, on rows, drop account and then order (order under account) and that will do it

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡