Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a data that collected monthly and quarterly. Now I want to visualize it using Matrix. However, I want to show the quarterly data by merging the cells together as shown in the images below.
For example, my visualziation is currenly looking like below.
And I want to make it look like the following:
Can anyone please tell me if it is possible to achieve this in Power BI Matrix visualization?
Solved! Go to Solution.
Hi @Anonymous
It is not supported to you to merge cells by columns in Matrix currently in Power BI.
Try to add your hierachy in Matrix Rows.
If your sample is as below, try to fill up the values in Documents and Books, then select ID and Value column and use Pivote function in Power Query Editor.
New Table:
Build a martix visual as below, and you need to turn off Stepped layout in Rowheader in Format.
Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
It is not supported to you to merge cells by columns in Matrix currently in Power BI.
Try to add your hierachy in Matrix Rows.
If your sample is as below, try to fill up the values in Documents and Books, then select ID and Value column and use Pivote function in Power Query Editor.
New Table:
Build a martix visual as below, and you need to turn off Stepped layout in Rowheader in Format.
Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , I doubt you can merge like you have shown. You can have Qtr(along with Mon year) also on the column and there you get sub total of the qtr.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |