Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a pie chart that's showing true/false values, and instead of the legend just saying True or False, I'd like to rename them to something more intuitive. But I can't figure out how. Can anyone point me in the right direction?
Solved! Go to Solution.
Okay. So the new column should be
IF(Table[Value] = "True", "Trainer", "Outside")
Now create a pie chart using this new column.
Does this help?
Hi @JClishe,
By my test, I couldn't reproduce your visual well, could your share some data sample or attach your Pie chart which could reproduce your scenario so that we could help further on it?
Best Regards,
Cherry
Here's what the pie chart looks like. In the source system that Power BI is pulling data from, this field is just a check box. If it's checked, Power BI sees it as True. If it's not checked, Power BI sees it as false.
Hi @JClishe,
How about creating a column using an IF condition,
If(table[Value] = TRUE, "X", "Y")
Does this solve your problem?
Im not sure how to do this, can you provide more details?
Hi @JClishe,
I am assuming that you have a column with values True and False. My understanding is that you wish to call Replace True and False with more intuitive values.
I am recommending you create another column to using an If condition such that it displays textABC if value is true else Text XYZ.
Do I understand your problem correctly?
You understand me correctly; the issue is me understanding what to do. I'm very green with Power BI and have never created IF conditions.
Hi @JClishe,
What do you want the label to say when it is True and when it is False? I can help you write an IF Condition.
Okay. So the new column should be
IF(Table[Value] = "True", "Trainer", "Outside")
Now create a pie chart using this new column.
Does this help?
That worked. Only issue was it errored out but I was able to figure out that True shouldn't be in quotes.
Thanks for the help!
Hi @JClishe,
How about creating a column using an IF condition,
If(table[Value] = TRUE, "X", "Y")
Does this solve your problem?
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |