Forum Discussion
Helper VHow to display a pivot table with text values?
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......
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.⚡
5 Replies
- parry2k
Super User
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.⚡
- 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/
jdubsMy 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
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.⚡
