Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mossshvlw
Helper II
Helper II

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

Hi all,

 

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

 

chart.PNG

 

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:

 

format.PNG

 

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.

4 REPLIES 4
v-rzhou-msft
Community Support
Community Support

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

v-rzhou-msft
Community Support
Community Support

Hi @mossshvlw 

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

My Sample:

1.png'

Measure:

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

Result:

1.pngBest Regards,

Rico Zhou

 

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

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
Helper II
Helper II

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.