Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to Solution.
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 _ Jing
Hello @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
Hello @v-jingzhang , @tex628
Thank you for the suggestion of using ISINSCOPE. Since I am only using one column in my Matrix, I could not figure out how to make this fucntion work. But combining your suggestion with @tex628 , I thought perhaps HASONEVALUE might work.
Audits_PercentBucketCount = IF(HASONEVALUE(FACT_SafetyAudits_ALL_NRT[6HourBucket_Local] ),
[Audit_PercentCount], BLANK() )
But this doesn't work either, because there are rows in my matrix where One Value for a Facility does occur and hence does not blank out the % in the Total Column. As @tex628 mentioned,I need to "identify the % Totals" column and I am unable to figure out how to do this.
Thanks again for your efforts and suggestion to guide me along.
Best Regards,
Hello @v-jingzhang ,
Awesome. I got this latest solution to work. Thank you again very much for your time and efforts to resolve this one.
Kudos and Best Regards,
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
Hello @tex628 ,
Thank you for the suggestions. I will give these a shot to see which one works out best.
Thanks again and best regards,
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |