sex is showing as number in powerbi

(3) Share

Report

Posted on by CU07011049-0

I need help please, the sex column is showing as numbers, how can i change it to text

Categories:

Final app challenge

Screenshot 2025-0...

I have the same question (0)

All responses (8)

Answers (1)

timl 36,391 Super User 2025 Season 2 on at

Like (1)

Report

Hi @CU07011049-0

Can you confirm how the sex column is setup in Dataverse? Is it setup as a Choice where Male=0 and Female=1?

Was this reply helpful? Yes No
CU07011049-0 34 on at

Like (0)

Report

yes

Was this reply helpful? Yes No
Suggested answer

timl 36,391 Super User 2025 Season 2 on at

Like (1)

Report

Hi @CU07011049-0

Thanks for clarifying that. When you import/transform the data, there should hopefully be a yourprefix_sexname column that returns the sex description.

Can you try adding that?

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Was this reply helpful? Yes No
timl 36,391 Super User 2025 Season 2 on at

Like (1)

Report

Hi @W.P

I assume that you managed to sex description to display based on your other post.

For the benefit of any one else who wants to displays the descriptions rather than numbers for Power BI 'multi-choice' columns, this post may help.

https://community.powerplatform.com/forums/thread/details/?threadid=f8f2fba2-d4e5-ef11-a730-7c1e52465fa1

Was this reply helpful? Yes No
CU07011049-0 34 on at

Like (0)

Report

I do not have the sexname column when i was importing the data, I saw for other multiple choice column but for sex, it wasnt there

Was this reply helpful? Yes No
Verified answer

timl 36,391 Super User 2025 Season 2 on at

Like (0)

Report
Hi @CU07011049-0

In response to your question here, here's the formula to add a column to display the sex description.

https://community.powerplatform.com/forums/thread/details/?threadid=f8f2fba2-d4e5-ef11-a730-7c1e52465fa1

This works on the basis of Male=1 and Female=2.

If the choice ids/descriptions are setup differently for you (refer to the screenshots at the start of this post), you would adapt the formula as necessary.

SexDesc = IF([Sex] = 1, "Male", "Female")

Was this reply helpful? Yes No
CU07011049-0 34 on at

Like (1)

Report

Thanks so much,

the formula worked, though initially there was an error, i needed to change the data type of sex from text to whole number for it work.

Was this reply helpful? Yes No