Percentage of column total

[HieuTran]

Hello, so I'm trying to make the values shown in my stacked column chart to be similar to what's being shown in my Matrix. I've played around with PowerBI for quite a while but still haven't figured this out, can anyone help me to look into this?

If I understand this correctly, the mismatch is caused by the fact that there is no option for "Show value as column total" for stacked column chart. Is there a workaround for this?

[v-juanli-msft · Accepted solution]

Hi @HieuTran

Assume  your dataset is like this

You could create a measure as a workaround

percentage = SUM(Table1[percent])

Measure = DIVIDE([percentage],CALCULATE([percentage],ALLSELECTED(Table1[answer])))

Best Regards

Maggie

[HieuTran]

Thanks! It does work!