Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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, ...........................
Solved! Go to 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.
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.
Thanks Zeon
That was what I thought, it's nice to be confirmed by a community support member.
@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:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.
@Akechi
Sorry, not getting it, can you attach a file with sample data and provide a clear explanation ?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello Fowmy
Here is the link of a sample
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |