How to display table with below format?

[Anonymous]

Hello,

We need to display data as below format in Power BI report?

Thanks.

[Mann · Accepted solution]

Hi @Anonymous 

You can use Matrix visual for this requirement.

From your screenshot below it is hard to understand the underlying table with "value" column granularity. I considered the underlying table to be like this:

If thats true than you can use Matrix visual and do these steps:

1) Drag all these three columns to Rows

2)  Go to visual properties--> Row Headers--> Turn off Stepped Layout and +/- icons

3) Then from visual ellipses click twice on 4th option which says "Expand all down one level in hierarchy"

Below visual will be come:

Mann.

[Mann · Accepted solution]

Hi @Anonymous 

You can use Matrix visual for this requirement.

From your screenshot below it is hard to understand the underlying table with "value" column granularity. I considered the underlying table to be like this:

If thats true than you can use Matrix visual and do these steps:

1) Drag all these three columns to Rows

2)  Go to visual properties--> Row Headers--> Turn off Stepped Layout and +/- icons

3) Then from visual ellipses click twice on 4th option which says "Expand all down one level in hierarchy"

Below visual will be come:

Mann.

[Anonymous · Accepted solution]

@Mannyes, it works, thank you very much for your quick help 🙂

[Greg_Deckler]

Use a Matrix.