How to filter table by a value as a category

[TomasPac]

Please help..

I need table values "Object" to be as a category for other values:

I will write some examples:

1. The column "Object" in my table holds site names, which are making supply orders.

2. Each site has it's own orders as a table row.

3. There are many different kind of data for an order, like "supplier", "quantity", "price", "date planned" and so on.

So right now if one "Object" has 5 supply orders, my table has 5 different rows with the same "Object" value.

What I need is "Object" values ​​to be like a category for every other subcategory and value.

What I have now:

 Object | order no | quantity | price | date planned

  site1       order1        10         20         2021-01-01 

  site1       order2        20         30         2021-01-01

  site1       order3         5          15         2021-01-04

  site2       order4        30         20         2021-01-06 

  site2       order5        50         100       2021-01-10

 What I need:

 Object | order no | quantity | price | date planned

  site1 ------------------------------------------------- 

                 order1       10          10       2021-01-01

                 order2       20          30       2021-01-01

                 order3        5           15       2021-01-04

  site2 ------------------------------------------------- 

                 order4      30           20       2021-01-06

                 order5      50          100      2021-01-10

[v-jingzhang · Accepted solution]

Hi @TomasPac 

Please format the matrix visual like below.

Put Object and Order No. columns in Rows fields, put other values in Values fields. Go to Format > Row headers > turn off Stepped layout and +/- icons.

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[amitchandak]

@TomasPac , check with stepped layout off and expand all  in a matrix

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#stepped-layout-with-matrix-v...