Hi all, I tried many solutions but does not work. I would like to create a pie chart which can display agree and disagree percentage. However, my numbers are not from any data source, so I have created a calculated field under IF statement.
IF [Opinion] = "Agree" then "0.4"
END
The pie chart I would like to show is agree and disagree together but this does not work for me. After I put agree to row, the pie chart become full color but I want it displayed as 40% of the pie chart.
Many thanks in advance!
Hi @Miyazaki Sakura
Here is one option using Measure Names and Measure Values - feels a little hacky though.
NB: I've used sample superstore Category rather than Opinion but it's the same concept.
Agree = IF [Category]='Furniture' THEN 0.4 END
Disagree = 1-[Agree]
So you were kind of halfway there and just needed the remaining 60% (Disagree calc) I think
Thoughts?
Ta, Steve.
