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

Pie Chart not showing values properly?

Hi All,

i trying to create Pie chart, some values are not showing properly can any one suggest how to show properly

please see below pie chart for your reference

.Capture.PNG

Thanks in advance

Rajesh

1 Solution

Accepted Solutions
qv_testing
Specialist II
Specialist II

Stagger labels working for me..

Try Once...

Capture.PNG

Dual(

  Num(SUM(Expression), '#,##0') &

  Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),

  SUM(Expression)

)

View solution in original post

9 Replies
Chanty4u
MVP
MVP

you will get some help from below thread

Pie chart not showing properly

avinashelite

The values are showing properly but its overlapping , if you observe all the values at the lower range are overlapping because they don't have the space to show the complete values properly ...other two values have good space and hence the numbers are visible . Better hide the value on data points and show only in the legend


Hope this helps you .

qv_testing
Specialist II
Specialist II

jonathandienst
Partner - Champion III
Partner - Champion III

If exact values need to be visualised, you are better off using a bar chart than a pie.

You usually do not need much detail for the 'rats and mice" , so you could:

  • Conditionally hide the small values (click + next to the expression and enter a condition under show values.
  • Use Dimension Limits to group the small value into 'Others'.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Rajesh
Creator II
Creator II
Author

Thanks all for your value suggestions

Staggering labels not working in this, may be my dimension have 5 values only.

qv_testing
Specialist II
Specialist II

Stagger labels working for me..

Try Once...

Capture.PNG

Dual(

  Num(SUM(Expression), '#,##0') &

  Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),

  SUM(Expression)

)

Rajesh
Creator II
Creator II
Author

Thank you Raju..

its working now as expected.

Not applicable

U can try Staggering labels but if u really want to show values instead of percentages better go for bar-chart. Pie charts are meant to show percentages.