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. ...
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

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!