Forum Discussion
Create a clustered column chart from counting text values in various columns
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
Resident RockstarHi 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
v-piga-msft That worked! Thank you so much!
- v-piga-msft
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