Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I've been doing some research and have discovered that table visual requested is not support, but last I found was from 2023. Is this still not supported. I would like to recreate the following table in BI visual. I have created a matrix table using all columns in the row section and pounds/cases in the value section. However, I would like row total of top level item group only and when row subtotals is turned on in format visual I get row subtotals per row for each group. Is there a solution to the likes of the table provided, any recommendations appreciated. Thank you.
Item ID | Date Requested | Order # | Order Date | Site | Pounds | Cases |
00061 | 1/4/25 | TX00027768 | 1/3/2025 | 01 | 39,600 | 22 |
00061 | 1/6/25 | TX00027789 | 1/6/2025 | 01 | 39,600 | 22 |
00061 | 1/6/25 | TX00027790 | 1/6/2025 | 01 | 39,600 | 22 |
00061 | 1/6/25 | TX00027791 | 1/6/2025 | 01 | 39,600 | 22 |
00061 | 1/8/25 | TX00027820 | 1/8/2025 | 01 | 39,600 | 22 |
00061 | 1/8/25 | TX00027821 | 1/8/2025 | 01 | 39,600 | 22 |
Total | 237,600 | 132 | ||||
00064 | 1/7/25 | TX00027814 | 1/7/2025 | 01 | 1,800 | 1 |
00064 | 1/9/25 | TX00027849 | 1/9/2025 | 01 | 1,800 | 1 |
Total | 3,600 | 2 | ||||
00073 | 12/30/24 | TX00027724 | 12/30/2024 | 01 | 39,600 | 22 |
00073 | 1/3/25 | TX00027769 | 1/3/2025 | 01 | 39,600 | 22 |
00073 | 1/6/25 | TX00027792 | 1/6/2025 | 01 | 39,600 | 22 |
00073 | 1/7/25 | TX00027816 | 1/7/2025 | 01 | 10,800 | 6 |
00073 | 1/8/25 | TX00027822 | 1/8/2025 | 01 | 39,600 | 22 |
00073 | 1/9/25 | TX00027842 | 1/9/2025 | 01 | 39,600 | 22 |
00073 | 1/9/25 | TX00027843 | 1/9/2025 | 01 | 39,600 | 22 |
00073 | 1/9/25 | TX00027844 | 1/9/2025 | 01 | 39,600 | 22 |
Total | 288,000 | 160 |
Solved! Go to Solution.
Hi,@victor_p .I am glad to help you.
It looks like you want to show row subtotals and totals in visual
Similar to a table (with more rows of totals sorted by group than a normal table)
Maybe you can try to show the measure in matrix, where you can use the isincope function to control the output of the measure (to control the value of the total column).
The Values area holds the measure of the displayed data.
I have noticed that there are other users who have similar problems as you, so I hope this helps:
Solved: How to show group counts and totals in table or ma... - Microsoft Fabric Community
The isincope function controls the output of the total column.
Solved: Re: Counting on row level unique values in MatrixT... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@victor_p .I am glad to help you.
It looks like you want to show row subtotals and totals in visual
Similar to a table (with more rows of totals sorted by group than a normal table)
Maybe you can try to show the measure in matrix, where you can use the isincope function to control the output of the measure (to control the value of the total column).
The Values area holds the measure of the displayed data.
I have noticed that there are other users who have similar problems as you, so I hope this helps:
Solved: How to show group counts and totals in table or ma... - Microsoft Fabric Community
The isincope function controls the output of the total column.
Solved: Re: Counting on row level unique values in MatrixT... - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |