Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 show up either. Is there a way to show $0 in a stacked bar chart?

Need Help

5 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    it is difficult to answer correct without data example but try to set active parameter "Show item with no data" in AXis field settings in Visualization pane

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi 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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello 

       

      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