cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitexo87
Post Prodigy
Post Prodigy

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 @vitexo87,

 

   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#

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

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

So I can help you better.

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors