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
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,