Matrix - show percentage only on total Column

[BSTRE]

Hello,

I have a matrix table filled with values in normal number format

I am just looking to add a percentage 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 to my matrix table? And not have the % on each column under the Year/Week

Thanks! 

[mtanner_danby]

I'm having the same issue - was this ever solved with the Matrix visual?

[Nathaniel_C]

Hi @BSTRE ,

Have you tried to format that measure as a percentage?

When you have your measure in the edit window, go to the modeling tab.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[BSTRE]

Hi @Nathaniel_C 

Thanks for the quick response and trying to help. 

What I'm looking for is to not have the Percentage on each column but only in the Grand Total. Right now I do have the percentage but across every column, which I don't need. 

Makes sense?

Best, 

[Nathaniel_C]

@BSTRE ,

What about two measures that are the same. Percentage weekly, Percentage Total, formatted differently, or am I misunderstanding the issue?

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Nathaniel_C]

@BSTRE , and divide by 100 for the total ,

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[BSTRE]

@Nathaniel_C 

I have both measurements in multiple Columns (Year/Week) and I only want to have the Percentage on the Total Column (The last one)

Does it make sense and is it possible?

[v-diye-msft]

Hi @BSTRE 

Do you mean you'd like to remove the measure in the previous columns, but only keep the percentage in total column? It's not accessible in Matrix, the nearest workaround is to change the values as blank rather than totally remove them, but the title of "% Total" will still exist.  

Let me know if you'd like to get this result, I'll draw it up for you.