Forum Discussion
Matrix Visual - Hide Percent Total
Good Afternoon,
Have a Matrix Visual showing Value and Percentage. In the Value dropdown, I am using the option to "Show as % of row total"
The Percentage Total of 100% is redundant. Is it possible to hide Total Percent but retain Total Audits?
Thanks and Best Regards,
8 Replies
Hi rsbin
You could insert a rectangle shape and put it on the column to cover it. Group the shape and Matrix visual. Fill the shape with the same color as Matrix's background and switch off its outline.
Best Regards,
Community Support Team _ JingHello v-jingzhang ,
Thank you for this suggestion. I've been able to get this to work temporarily. My concern is the Matrix size will change i.e. new rows added. Then I believe I will have to keep extending or modifying the shape to cover the added rows. I still think a Measure is the cleanest option...just haven't been able to figure that one out yet.
Thanks again and kudos for this "quick fix"
Hi rsbin
I understand. For a measure option, you could try ISINSCOPE function in the measure. Something like IF(ISINSCOPE('tablename'[columnname]),[measure],BLANK())
Example: total value corner matrix - Microsoft Power BI Community
BR,
Jing
Hi rsbin,
I'd suggest either of two options here:
- You can manually hide the "%" totals column by removing word wrap and then minimizing the column width, this will be maintain when you publish the report.
- If you remake the calculation as a measure you can identify the totals column and then force a BLANK() statement there instead. This will remove the "100%" values but the column will still remain.
Br,
J
