Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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!
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!
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
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
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.
@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?
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |