Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a clustered column chart from counting text values in various columns

I am trying to create a clustered column chart that shows the count of each score from 9 different categories:    SAF           W            M           SYS       ERM     ENV         COM        ET ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    For your requirement, you could unpivot all your columns and change the Attribute to Category then you will get the table like this .

     

     

    Then you could create the measures below.

     

    E = CALCULATE(COUNT(Table1[Value]),FILTER('Table1','Table1'[Value]="E"))
    
HE = CALCULATE(COUNT(Table1[Value]),FILTER('Table1','Table1'[Value]="HE"))
    
N = CALCULATE(COUNT(Table1[Value]),FILTER('Table1','Table1'[Value]="N"))
    
NE = CALCULATE(COUNT(Table1[Value]),FILTER('Table1','Table1'[Value]="NE"))
    
US = CALCULATE(COUNT(Table1[Value]),FILTER('Table1','Table1'[Value]="US"))

    Then you could create the visual below.

     

     

    More details, please refer to this attachment.

     

    Best  Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-piga-msft That worked! Thank you so much!

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

 

It's glad that we can help.

 

Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,

Cherry