Forum Discussion
% Of Row Total
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?
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
2 Replies
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
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!
