How to display 0% in a stacked column chart

[pminnov]

Hi, 

I have a measure that results in 0% when certain slicer conditions are applied. The measure counts the number of times 'yes' appears in a column and divides by the total number of rows. I'm using a column chart to graph the percentages across years (% on y-axis, years on x-axis) however the value of 0% will not display anywhere on the chart. 

However if I use a line chart to display the same measure with the same slicer conditions applied, it will show the 0% value. 

The option to show items with no data isn't available for the measure. Is there a workaround for this? 

Thanks!

[lbendlin]

I think this is working as designed.  You can switch data labels on to see that it is being rendered.

[pminnov]

But is there a way to show 0% on a column chart the way it is displayed on a line chart (rather than not showing any data points at all)?

[lbendlin]

Sounds like an episode of "Lying with data" ...

So no, not really, unless you want to bend reality.

[pminnov]

It's lying with data to show 0% as a data point on a line chart but not a column chart? 

[lbendlin]

There's a difference between line thickness and number of pixels per column element. In the latter case a value of 0 results in zero pixels for rendering. In the former case the line has the same thickness regardless if it goes through 0 or not.

[pminnov]

Understood but in the line graph 0% is represented by a dot which indicates there is a value. In the column chart, even though data labels are turned on, it is blank. I was hoping to somehow indicate that there is data (i.e., not blank) even if it's just a data label but it looks like that's not possible.