Setting format of data labels (i.e. rounding) for chart showing aggregate data of text format

[mossshvlw]

Hi all,

I have a text column that is simply "Male" or "Female".  I'm creating a chart to tally those counts:

I want the decimal places to be rounded.  I'm trying to do this by clicking on the column and going to 'column tools' to set the formatting:

But the option to format the number is greyed out since it's a text column.  I want to keep the column text, aggregate it as I've done, and simply report the label percentages as rounded numbers.  Any help appreciated.  Thanks in advance.

[Anonymous]

Hi @mossshvlw 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[Anonymous]

Hi @mossshvlw 

You can try to build a measure then use measure tool to achieve your goal as well.

My Sample:

'

Measure:

Sex Percentage = DIVIDE(COUNT('Table'[Sex]),COUNTAX(ALL('Table'),'Table'[Sex]))

Result:

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[mossshvlw]

RicoZhou, Thanks for the reply.  I did not accept this answer since there was a much simpler solution I was overlooking, which I have stated in the thread below.  The Data Labels tab in the visualization pane is the easiest way to accomplish the rounding of the decimals.

[mossshvlw]

Nevermind.. figured out how to do it in the data labels tab.  thanks.