Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Snagalapur
Helper IV
Helper IV

how to exclude showing zero values in line graph

Hi All,

 

Kindly suggest how to exclude showing zero values in line graph

Note: as line graph has calculated values when i use filter other measures get cutdown to period 09.

 

Snagalapur_0-1732826006747.png

 

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @Snagalapur 

 

To exclude zero values from your line graph without affecting other measures or periods, you can modify your measure to return BLANK() when the value is zero. In Power BI, data points with BLANK() values are not plotted in line charts, effectively removing them from the visual.

 

Here's how you can do it:

Modify Your Measure:

Adjust the measure used in your line graph to return BLANK() when the result is zero. For example:

Adjusted Measure =
IF([Your Original Measure] = 0, BLANK(), [Your Original Measure])

Replace [Your Original Measure] with the actual measure you're using in the line graph.

Use the Adjusted Measure in Your Line Graph:

Replace the existing measure in your line graph with the new Adjusted Measure.
This will display all your data as before but will exclude the zero values from the line graph.

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

 

LinkedIn|Twitter|Blog |YouTube 

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thanks for the replies from Rupak_bi and VahidDM.

 

Hi @Snagalapur ,

 

I'll add one more detail here: If, after making changes to the measure, some data points are missing from the x-axis, you can select the X-axis field and click "Show item with no data".

vlinhuizhmsft_0-1732848121603.png

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

VahidDM
Super User
Super User

Hi @Snagalapur 

 

To exclude zero values from your line graph without affecting other measures or periods, you can modify your measure to return BLANK() when the value is zero. In Power BI, data points with BLANK() values are not plotted in line charts, effectively removing them from the visual.

 

Here's how you can do it:

Modify Your Measure:

Adjust the measure used in your line graph to return BLANK() when the result is zero. For example:

Adjusted Measure =
IF([Your Original Measure] = 0, BLANK(), [Your Original Measure])

Replace [Your Original Measure] with the actual measure you're using in the line graph.

Use the Adjusted Measure in Your Line Graph:

Replace the existing measure in your line graph with the new Adjusted Measure.
This will display all your data as before but will exclude the zero values from the line graph.

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

 

LinkedIn|Twitter|Blog |YouTube 

 

Thank you for help.

Rupak_bi
Super User
Super User

Hi @Snagalapur ,

If the values are coming from column, put filter of those in the filter pane. J

If values are coming from a measure,

Put an if logic in the measure 

If ( max( table,value)= 0, blank(), the original 

  • Logic of the measure)).
  • If fails, please share sample dataset


Regards
Rupak
FOLLOW ME : https://www.linkedin.com/in/rupaksar/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.