How do I place the decimal on the labels?

[Anonymous]

Hello!

I would like to know how the decimal can be able on a label which comes from a categorical variable and here that "total number of respondents" is the count.

Thank you very much 🙂

[Anonymous]

Hello

Thank you but you can't, it's text because it's categorical and therefore when I try to change it to number it gives me an error.

[amitchandak]

@Anonymous , Create a count measure and set format to have one decimal place. 

[Pragati11]

Hi @Anonymous ,

Try chnaging the data-type to Decimal Number.

Thanks,

Pragati

[Anonymous]

Thank you for your input but it is a categorical variable, it does not allow to do it

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create a column

Column = FORMAT( CONVERT([Column1],DOUBLE),"#,#")

[Column1] is a column of text type,

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.