Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below pie chart and would like to remove the decimals; where do I do that?
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
I chose to use Share to get percentages:
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,
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
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
@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?])
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!!