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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

how to remove null information from objects?

how to remove null information from objects?Untitled.png

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

Okay I kind of recreated your chart below - see in the Filters area - Month(All) - underlined

 

Chart1.png

Next step is to apply the filter as in the picture below and hit apply filter and blanks are gone

 

Chart2.png

 

But you clearly have values that are missing months/dates

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @Anonymous,

 

   a solution is change the type of the visualization to another that allows you to set a visual level filter to filter out the blank values.

 

blankValues.png

Let Me Know If It Works.

 

#I'M Not An Expert#

Anonymous
Not applicable

Thanks @ B129, but and null values in a graph for example would look like? I already removed onths to filter reports and I started using only the filters you suggested but the void in the charts are still showing up

Anonymous
Not applicable

@Anonymous can you give me an example dataset similar to your datas?

So I can help you better.

Anonymous
Not applicable

is an example, this chart my size is the month and as you can see even applying the filters as you recommended the null information is still displyed

 

 

 

nulo.png

Sean
Community Champion
Community Champion

What B129 told you to do should have taken care of the Blanks

 

Post another screenshot that includes the Filters area

Sean
Community Champion
Community Champion

Okay I kind of recreated your chart below - see in the Filters area - Month(All) - underlined

 

Chart1.png

Next step is to apply the filter as in the picture below and hit apply filter and blanks are gone

 

Chart2.png

 

But you clearly have values that are missing months/dates

Sean
Community Champion
Community Champion

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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