How to rename true/false values in a pie chart?

[JClishe]

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?

[v-piga-msft]

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

[JClishe]

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. 

[Anonymous]

Hi @JClishe,

How about creating a column using an IF condition, 

If(table[Value] = TRUE, "X", "Y")

Does this solve your problem?

[JClishe]

Im not sure how to do this, can you provide more details?

[Anonymous]

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?

[JClishe]

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. 

[Anonymous]

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.

[JClishe]

Thanks for the offer. I'd like True to say "Trainer" and False to say "Outside".

[Anonymous · Accepted 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?

[JClishe]

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!

[Anonymous]

Hi @JClishe,

If this solved your problem, could you please mark it as Accepted?

Thanks 🙂

[Anonymous]

Hi @JClishe,

How about creating a column using an IF condition, 

If(table[Value] = TRUE, "X", "Y")

Does this solve your problem?