cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
birkenbiker Frequent Visitor
Frequent Visitor

Show 0% in bar chart

Hi,

 

I want to show in my bar chart the value for several components. Some of these are containing a 0% value. However, they won't be displayed in the chart so it looks like a blank value. Is there a possibility to show the 0% within the chart or at least show a difference between 0 and blank? 

 

Thanks in advance!

 

Best

 

Max

2018-05-18_11h01_08.png

1 ACCEPTED SOLUTION

Accepted Solutions
birkenbiker Frequent Visitor
Frequent Visitor

Re: Show 0% in bar chart

Ok I think I found a more or less suitable solution. By clicking on "auto" for the data position it shows me at leat the zeros. I had it on "center before" ...

 

Thanks for your help, guys!

 

2018-05-18_14h28_42.png

6 REPLIES 6
quentin_vigne Senior Member
Senior Member

Re: Show 0% in bar chart

Hi @birkenbiker

I don't know if it will work, but try to add ' + 0 ' at the end of your column, maybe this will display the value 0% because at the moment it is displayed as Blank()

 

Quentin

birkenbiker Frequent Visitor
Frequent Visitor

Re: Show 0% in bar chart

Hi Quentin,

 

there is already a 0 value in the column. It's the average, but I tried your suggestions also with a measure and a +0 at the end - no success. If I use the table widget or anything else the 0% will be shown. 

 

Best

 

Max

Floriankx Established Member
Established Member

Re: Show 0% in bar chart

Hello, I think the columns are there according to the legend.

 

Please make sure label colour for 0 values isn't white like the others.

 

Best regards.

birkenbiker Frequent Visitor
Frequent Visitor

Re: Show 0% in bar chart


@Floriankx wrote:

Hello, I think the columns are there according to the legend.

 

Please make sure label colour for 0 values isn't white like the others.

 

Best regards.


 

Well, the columns are my values. So there is nothing in legend, axis, etc... Only value and quickinfo. Since I only use the average of the columns A, B, C, ... this was the most appropriate solution for now. Maybe this is the mistake?

Shubham21 Frequent Visitor
Frequent Visitor

Re: Show 0% in bar chart

If you can use your [A,B,C,D,E] column or create a calculated column with these values and then use it on axis and select show items with no data.

That should do

birkenbiker Frequent Visitor
Frequent Visitor

Re: Show 0% in bar chart

Ok I think I found a more or less suitable solution. By clicking on "auto" for the data position it shows me at leat the zeros. I had it on "center before" ...

 

Thanks for your help, guys!

 

2018-05-18_14h28_42.png