Forum Discussion
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
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!
6 Replies
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_vigneSolution Sage
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
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
FloriankxHello, 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.
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