How to use 100% stacked column chart on categorical data?

[Daeglsy]

Hi all,

I got a survey data set that I'd like to visuallise with a 100% stacked bar chart. However I can't seem to figure out how to visualise it on a 100% stacked bar charts. The data set is something like this:

QuestionA: T, T, F, F, NA
QuestionB: F, F, NA, T, F
QuestionC: NA, NA, F, T, T

I wanted to put my questions as x axis, and percentage as y axis on a 100% stacked bar chart. Do I need to write something on DAX? Or are there anything that I've completely overlooked?

Thank you.

[Anonymous]

I have created a table like this : 

And then used different measures to count the percentages of the TRUE or FALSE or NA for each question: 

CountTrueQ1 = CALCULATE(COUNTROWS(FILTER('Q&A','Q&A'[Q1]="T")))/COUNTROWS('Q&A')*100

CountFalseQ1 = CALCULATE(COUNTROWS(FILTER('Q&A','Q&A'[Q1]="F")))/COUNTROWS('Q&A')*100

CountNAQ1 = CALCULATE(COUNTROWS(FILTER('Q&A','Q&A'[Q1]="NA")))/COUNTROWS('Q&A')*100

But I couldn't plot in the 100% stacked column chart, so now it is a challenge for me too 

I hope others can help 

[v-yuta-msft]

Hi Daeglsy,

Could you share some sample data for further analysis?

Regards,

Jimmy Tao