Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
Thanks! It does work!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |