Forum Discussion
Finding a Table Visual that groups a top level item
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
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.
4 Replies
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.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?
Hi DebbieE Did you turn off the "Stepped layout" option?
