Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper IV
1 year ago
Solved

How to avoid showing Zero value sin bar chart

Hi All,

Could you please share how to avoid showing Zero revenue/values in bar chart. 

I have conditional colour format for bar in view.

 

Thank you.

Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Snagalapur, In your case make Sum of Q3-24 ACT as not 0 like below

     

     

    Did I answer your question? If yes, please mark my post as a solution.

     

    Thanks,

    Jai

     

5 Replies

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Icon for Super User rankSuper User
    1 year ago

    Snagalapur Click the visual, then the check the right side to see the filters. Now locate the aggregated field and apply filter.

    Example: sum(table[revenue]) is not 0 


    Thanks,

    Jai

    • Snagalapur's avatar
      Snagalapur
      Icon for Helper IV rankHelper IV
      1 year ago

      could you please provide example, I couldnt  resolve issue.

       

      • Jai-Rathinavel's avatar
        Jai-Rathinavel
        Icon for Super User rankSuper User
        1 year ago

        Snagalapur, In your case make Sum of Q3-24 ACT as not 0 like below

         

         

        Did I answer your question? If yes, please mark my post as a solution.

         

        Thanks,

        Jai

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Jai-Rathinavel ,thanks for the quick reply, I'll add more.

    Hi Snagalapur,

    Check if you have selected this option. Uncheck it, as Power BI will automatically hide null values by default when using quick measure.

     

    Best Regards,
    Wenbin Zhou