Finding a Table Visual that groups a top level item

[DebbieE]

I have a visal that someone has specifically requested and I am really struggling to find something good to use

essentially they want a table and the first column has a 1 to many with the other columns. So they want this to be grouped as above. It doesnt seem like the Power BI Table can do this?

I tried a matrix but that doesnt work because the values are descriptions so it just brings the first one in.  Can anyone help me find a visual that will work in this way?

thanks in Advance

[v-jingzhang · Accepted solution]

Hi @DebbieE 

Table visual doesn't support that. You can use Matrix to get a similar result. In the matrix, you need to put all these four columns on rows. Then expand it to the lowest hierarchy. Turn off +/- icons and Stepped layout under Row headers. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[DebbieE]

that doesnt give me what I want. It just steps everything and only shows the title of the first column. 

It now makes no sense as a visual. Surely there must be something in Power BI that allows you to to this?

[DebbieE]

Ahhh I had missed the last step. Thats definitely getting there now as something we can use

[v-jingzhang]

Hi @DebbieE Did you turn off the "Stepped layout" option?