Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
HenrikS1
Contributor II
Contributor II

How to remove decimals in a pie chart

I have the below pie chart and would like to remove the decimals; where do I do that?
HenrikS1_0-1699534345069.png

 

Labels (1)
1 Solution

Accepted Solutions
MatheusC
Specialist
Specialist

Hi, @HenrikS1 

try this

As has already been done

1st - In the Presentation tab, remove the Percentage option and change it to value,

2° - In the expression, leave it as mentioned in the image Numeric format without decimal,


Now in the expression let:
Sum(sales)
/
sum(total sales)

3° for the values ​​to be correct, divide by the total of your measurement

I'll send a printout with the examples

 

MatheusC_0-1699540590671.png



MatheusC_1-1699540790966.png

 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

5 Replies
HenrikS1
Contributor II
Contributor II
Author

I chose to use Share to get percentages:

HenrikS1_1-1699535534562.png


In Data I then choose to not display any decimals, it still shows one and if I choose to show two still only one is shown,

HenrikS1_0-1699535456231.png

 

MatheusC
Specialist
Specialist

Hi, @HenrikS1 

try this

As has already been done

1st - In the Presentation tab, remove the Percentage option and change it to value,

2° - In the expression, leave it as mentioned in the image Numeric format without decimal,


Now in the expression let:
Sum(sales)
/
sum(total sales)

3° for the values ​​to be correct, divide by the total of your measurement

I'll send a printout with the examples

 

MatheusC_0-1699540590671.png



MatheusC_1-1699540790966.png

 

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
HenrikS1
Contributor II
Contributor II
Author

Thank you for your suggestions @MatheusC , but I am afraid I do not get what to do in the expression. Currently it looks like this:

=NUM(Count({<[delivery_:_status]={'On-going'}>}[risk_delay_eis?]),'#,###.%')

Or rather Count({<[delivery_:_status]={'On-going'}>}[risk_delay_eis?]) as I tried formatting here instead

MatheusC
Specialist
Specialist

@HenrikS1 

Changing the graph to value, you need to bring that representation back, so we use the total function

in your expression try this:


Count({< [delivery_:_status]={'On-going'}>}[risk_delay_eis?])
/

Count(total {< [delivery_:_status]={'On-going'}>}[risk_delay_eis?])

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
HenrikS1
Contributor II
Contributor II
Author

Thanks again for taking the time! I was confused as in Editing mode, the chart was just empty. Only when escaping that mode did the figures show and now without decimals. Brilliant!!