Flattening Row Hierarchy in Matrix Visual (new PBI version)

[BITomS]

Hi there!

I've got a matrix table visual with multiple fields within rows. This naturally creates a hierarchy, but I'd like the row to be flattened so that it only appears as one row. I have a value field and 2 column fields because I am partially grouping data.

There was a solution in the old version of PBI: https://community.fabric.microsoft.com/t5/Desktop/Matrix-visual-flatten-the-rows/m-p/2130530

But not sure if this has been replaced in the new version or if there is anywhere else we can modify this?

Any help is appreciated! Thanks in advance.

[amitchandak · Accepted solution]

@BITomS , refer to new matrix layout
https://youtu.be/f_DOvb_PDG0
You can check release notes - https://powerbi.microsoft.com/en-us/blog/power-bi-may-2024-feature-summary/#post-27048-_Toc167109007

[BITomS]

Thanks @amitchandak , so it's Layout and style presets and then 'Outline' or 'Tabular' that allows for this.