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.
Hello,
I have a matrix table filled with values in normal number format.
I also have a totals column.
I am just looking to add a percentages of the totals next to the totals column. I do not want to see percentages for each column that exists. Just the totals column.
How can I add this one column addition onto my matrix table?
Solved! Go to Solution.
Hi mpichardo,
Do you mean someting like this?
I could not find an "official" way to hide the % column for each year. What is did is just make the column smaller.
Also I changed the formula, to exclude values for the year level.
% of total =
IF (
ISFILTERED ( 'Date'[CalendarYear] );
BLANK ();
DIVIDE (
[Sum of SalesAmount];
CALCULATE ( [Sum of SalesAmount]; ALL ( FactOnlineSales ) )
)
)
Hope this helps.
Yes just like that, by the way, your code where did you write that? Into Calculated Column? I am trying to duplicate your formula for my table
You need to create a measure
Are you sure its a measure? Everytime I put in the semicolon I get an error I tried calculated column that didn't work either.
That is probably because the responder is from another country. I believe in Europe they use semicolons. Try to replace the semicolons with commas.
Yes @vega is right. It is a measure. and you may need to replace the ; with , Sorry about that.
Hi mpichardo,
Do you mean someting like this?
I could not find an "official" way to hide the % column for each year. What is did is just make the column smaller.
Also I changed the formula, to exclude values for the year level.
% of total =
IF (
ISFILTERED ( 'Date'[CalendarYear] );
BLANK ();
DIVIDE (
[Sum of SalesAmount];
CALCULATE ( [Sum of SalesAmount]; ALL ( FactOnlineSales ) )
)
)
Hope this helps.
How did you exclude the Value header and column subtotals for "% of total"?
I could not find an "official" way to hide the % column for each year. What is did is just make the column so small that you don't see it.
Oops, I forgot I had word-wrap on. Thanks for the quick response though!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |