Forum Discussion
Matrix and total for one column...
Hi All,
I have been googling for an answer to with a Matrix I want to just show one or two totals. I have turned off subtotal for rows and I read something about turning off group total but can not find it. Basically I want
id name deposit
1 mark 100
200
total 300
2 sue 200
1000
300
total 1500
I hope this makes sense.
Hi, Anonymous
Based on my research, I created data to reproduce your scenario.
You may create a measure as follows.
DepositValue = IF( ISFILTERED('Table'[Deposit]), BLANK(), SUM('Table'[Deposit]) )Then you can make the matrix visual selected, go to 'Format' ribbon, click 'Row headers', uncheck 'Stepped layout', then click 'Subtotals', check 'Row subtotals' and 'Per row level', finally set Id and Name as Off and Deposit as On.
Finally you need to confirm that 'show data without item' is checked. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
In the options for the Matrix there is a section called "Subtotals". Under that section is a toggle called "Per Row Level" and "Per Column Level". Toggling either of these on will give you options to change which levels of your rows/columns will have totals.
These are a fairly new addition to Power BI, so make sure you have the latest version of Power BI Desktop
Sample source data would help. There is an option for row headers to turn off stepped layout, which may be what you are looing for. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi, Anonymous
Based on my research, I created data to reproduce your scenario.
You may create a measure as follows.
DepositValue = IF( ISFILTERED('Table'[Deposit]), BLANK(), SUM('Table'[Deposit]) )Then you can make the matrix visual selected, go to 'Format' ribbon, click 'Row headers', uncheck 'Stepped layout', then click 'Subtotals', check 'Row subtotals' and 'Per row level', finally set Id and Name as Off and Deposit as On.
Finally you need to confirm that 'show data without item' is checked. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide sample data, sample output you want.
In between refer to this :https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
