Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am working on a Tabular Report where I am getting the data as -
TextCol1 | TextCol2 | TextCol3 | TextCol4 | NumericCol5 |
A | AB | ABC | D1 | 1 |
A | AB | ABC | D2 | 2 |
A | AB | ABC | D2 | 3 |
A | AB | ABC | D4 | 4 |
But I want to Merge/Group the row data in the first 3 columns as below -
I tried using the Matrix stepped layout but couldn't achieve the exact format. Can anybody explain how to achieve this functionality using table or Matrix.
Solved! Go to Solution.
@Arora_Sangeet , refer this
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Please check details of format the matrix in my pbix.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please check details of format the matrix in my pbix.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Arora_Sangeet , refer this
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
@Arora_Sangeet Did you try turning off the stepped layout? You may also have to play with which fields are summarized, and could try this in a table visualization as well depending on your data, and as you add the columns to the 'values' click the down arrow to determine if they should be 'don't summarize' or 'sum' or something different.
With the table you'll get the subheadings repeating, with the matrix you'll get something similar to (so will have one extra row of headings from what you want):
You can always play with font colour for headings and add shapes if really needed.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |