% Of Row Total

[tywoodworth]

Hello,

So I want to show the below table with the % of row total but I only want to show the % for the Utilized column . If I try to exclude the other % columns from the visual it excludes the unit column as well.

Does anyone know of a way to do that?

[Greg_Deckler · Accepted solution]

@tywoodworth You might be able to do something in a measure to show BLANK unless it is in the Utilized Hours column. Otherwise, turn off word wrap and then shrink your unwanted columns. Another way is a custom matrix hierarchy: The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

[tywoodworth]

This word wrapping trick worked for the most part but you were right it still didn't look great. I ended up finding a better way and figured out how to add the calculations I needed. Thank you!