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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors