cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Minty7
New Member

omit null values

The data source for a dashboard is excel. The resultset is one value and the rest are null. How do you omit the null value given certain column for a label?

1 ACCEPTED SOLUTION

Accepted Solutions
rajendran Resident Rockstar
Resident Rockstar

Re: omit null values

To ans wer your specific needs - If you just need only the Top row always, In Query Editor -> Home Tab- > Keep Rows->Keep Top Rows-> Enter 1 as row, this will keep the top row only.

 

If you want to apply a filter on column level, you can apply a filter to remove the NULL rows.

 

Thanks
Raj

View solution in original post

4 REPLIES 4
v-piga-msft Resident Rockstar
Resident Rockstar

Re: omit null values

Hi @Minty7,

 

It seems that you 're using excel as data source. Do you get data from Power BI Service or Power BI Desktop?

 

What is your data sample like?

 

I 'm not very clear about your scenario, could you description in more details about your problem? You may could show some screenshots to specify it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Minty7
New Member

Re: omit null values

I'm not at my pc to post a screenshot. One of the columns in the excel file only has 1 value. The rest of the rows are blank. This will always be the case for this column. I only want the 1st row. The value will always appear in the 1st row.
rajendran Resident Rockstar
Resident Rockstar

Re: omit null values

To ans wer your specific needs - If you just need only the Top row always, In Query Editor -> Home Tab- > Keep Rows->Keep Top Rows-> Enter 1 as row, this will keep the top row only.

 

If you want to apply a filter on column level, you can apply a filter to remove the NULL rows.

 

Thanks
Raj

View solution in original post

Minty7
New Member

Re: omit null values

It wroks, thank you!

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors