Forum Discussion
Rollup Rows and Table Visual
Hi, I have a table created using summarizecolumns and rollupaddissubtotal. I want to display this in a table visual. I want the rolled up row to appear as the total row in the visual. I am able to put this easily into a table visual, but the total row appears as a normal row. How to I tell the table visual, that a particular row needs to be treated as the total row?
Can you help, your efforts are highly appreciated.
Hi senthilvaithi ,
According to your statement, I think you currently create a calculated table by SUMMARIZECOLUMNS() and use ROLLUPADDISSUBTOTAL() to add rows as subtotal in your calculated table.
Your requirement should be that show subtotals by group like the result in your calculated table.
As far as I know, Table visual support us show result based on row or column.
You can try matrix and add your groups in Row or Column Fields, than Power BI will show result by group ( in hierarchy level).
For reference:Create a matrix visual in Power BI - Power BI | Microsoft Learn
You don't need to create a calculated table, you can use columns from tables in matrix directly (different tables need to be related by columns).
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi senthilvaithi ,
According to your statement, I think you currently create a calculated table by SUMMARIZECOLUMNS() and use ROLLUPADDISSUBTOTAL() to add rows as subtotal in your calculated table.
Your requirement should be that show subtotals by group like the result in your calculated table.
As far as I know, Table visual support us show result based on row or column.
You can try matrix and add your groups in Row or Column Fields, than Power BI will show result by group ( in hierarchy level).
For reference:Create a matrix visual in Power BI - Power BI | Microsoft Learn
You don't need to create a calculated table, you can use columns from tables in matrix directly (different tables need to be related by columns).
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.