Group value in Matrix

[Anonymous]

Hi All,

Is it possible to group data in a matrix like in Reporting Services.

When I use grouping under Power Bi, I get

When I use grouping under Reporting Services in matrix, I get:

Is it possible to get the same effect as in Reporting Services?

[Anonymous]

Could You tell Me?

[v-diye-msft]

Hi @Anonymous 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye

[v-diye-msft]

Hi @Anonymous ,

Sorry for my late reply. 

yes, @tex628  is right!

Dina

[tex628]

Matrix -> Format -> Row headers -> Stepped layout OFF

[Anonymous]

Yes, I have it:

But I still get:

I think that's why there is a problem.

but, why is it only First, Last or Count? Why can not I deselect it?

[tex628]

Programs needs to be in rows, and not in values!

/ J

[v-diye-msft]

Hi @Anonymous 

Based on my research, there’re only 2 displays accessible currently as below, which different with the one you requested.

If you’d like bring your thought coming, you can put this idea in the portal, if people support it, dev team will take it into consideration.

Link: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best regards,

Dina Ye

[Anonymous]

How you created the first diagram?