is it possible to make a drilled down matrix looks like a normal table?

[Akechi]

the result shall look like:

city 1 , category1,paraname 1, paraValue1 ,  # value , % Value, ...........................

city 1 , category1,paraname 1, paraValue2 ,  # value , % Value, ...........................

city 1 , category1,paraname 2, paraValue3 ,  # value , % Value, ...........................

city 1 , category1,paraname 2, paraValue4 ,  # value , % Value, ...........................

city 1 , category2,paraname 3, paraValue5 ,  # value , % Value, ...........................

city 1 , category2,paraname 3, paraValue6 ,  # value , % Value, ...........................

city 2 , category3,paraname 4, paraValue7 ,  # value , % Value, ...........................

[v-angzheng-msft · Accepted solution]

Hi, @Akechi 

As far as I know, this can't be done unless you change the data model and replace the matrix with a table.
This is by design and it makes the row hierarchy more visible.
If the row hierarchy is not striking enough for you, then you can turn on the collapsed icon under Row headers and turn on the horizontal grid and change the thickness and color of the gridlines under Grid.
Then you will get the following result:

This is enough for me to make me clear. Hope it's also useful to you.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Akechi]

Thanks Zeon

That was what I thought, it's nice to be confirmed by a community support member.

[Fowmy]

@Akechi 

Not very clear but as I understood, you can use the CONCATENATEX function to join the value in a measure: Check the following similar example:

[Akechi]

Hi Fowmy

Thanks for your reply.

I know the solution of combining columns. 

What I need here is to make the matrix looks like a fake table.

To make the parent row grids act like normal cells.

I have played the same trick in SSRS.

Wonder if power BI can do the same. 

Thank again for your quick reply.

[Fowmy]

@Akechi 

Sorry, not getting it, can you attach a file with sample data and provide a clear explanation ?

[Akechi]

Hello Fowmy

Here is the link of a sample

https://app.powerbi.com/groups/me/reports/6ed1901d-31db-407b-870a-686dfa0fa719/ReportSection?redirec...