Forum Discussion
Anonymous
6 years agoNot applicable
Show 0 value in Stacked column chart
I am working on a finance dashboard and there are $0 value in a column in the database. However, this does not show up in a stacked bar chart. It looks like the chart is broken. The tooltip does not ...
v-eachen-msft
Community Support
6 years agoHi Anonymous ,
You could try to add "+0" in your formula to show numbers. You could provide your sample data and excepted result if you don't have any confidential information. Please upload your files to OneDrive and share the link here.
Anonymous
6 years agoNot applicable
Hello v-eachen-msft
I'll try to recreate a sample data set as I'm working with confidential information. Either adding a if condition with 0.00001 or +0 did not help me in the standard Power BI stacked column chart.
I used a custom power bi chart from Akvelon and I set a 0.00001 condition and I do see a bar on the 0.
It will be good to have this functionality in the Power BI Stacked column chart.
I'll add the sample to one drive and share soon.
thanks and appreciate your help