Forum Discussion

rsbin's avatar
rsbin
Community Champion
4 years ago
Solved

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 ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

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

rsbin's avatar
rsbin
Community Champion
4 years ago

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"

    • rsbin's avatar
      rsbin
      Community Champion
      4 years ago

      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,