Forum Discussion

birkenbiker's avatar
birkenbiker
New Member
8 years ago
Solved

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 ther...
Need Help
  • birkenbiker's avatar
    birkenbiker
    8 years ago

    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!

     

quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

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's avatar
birkenbiker
New Member
8 years ago

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's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    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's avatar
      birkenbiker
      New Member
      8 years ago
      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?