Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line chart without zero values

Hi Power BI Community!

I have this line chart:


I have also a slicer to just show one of the line charts:


Is there a way to just show one chart with values? = No zero values.

I already tried Filter greater than 0 but then nothing is shown.

Thankx for your time.

 

Need Help
  • dkaushik's avatar
    dkaushik
    5 years ago

    Hi Anonymous ,

     

    You can right click on your filed under "Axis" and de-select "Show items with no data". That should eliminate your zero line.

     

    It should work with a filter as well. Not sure what's happening there. Can you share a screenshot of your filter?

     

    Thanks,

    Dheeraj

4 Replies

  • dkaushik's avatar
    dkaushik
    Resolver II
    5 years ago

    Hi Anonymous ,

     

    You can right click on your filed under "Axis" and de-select "Show items with no data". That should eliminate your zero line.

     

    It should work with a filter as well. Not sure what's happening there. Can you share a screenshot of your filter?

     

    Thanks,

    Dheeraj

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      dkaushik It is a measure and it has worked! Thanks 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    dkaushik Thanks for the reply but I already tried that:

     

    Or this:
    = No chart because if is zero than it filters everything also with other seetings on the filter

     

     




     

  • joshyT7's avatar
    joshyT7
    Frequent Visitor
    5 years ago

    For your slicer, is this affecting a filter or a measure? 

    If you are using a measure, use an if statement with the result being BLANK() and this should remove the values from the chart. 

    Let me know how you get on!