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.
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.
Solved! Go to Solution.
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.
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/
Thanks for replying I supplied the example output the input would just be all the columns have the value repeated as shown.
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
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
Hi Many Thanks!
I have the Febuary version of Power BI Desktop (not the app store veresion) for using for the cloud tenant and it only has Row subtotals which I have turned off but no columnsubtotals under the subtotals.
Is the column subtotals somewhere else?
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |