Forum Discussion

Minty7's avatar
Minty7
New Member
8 years ago
Solved

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?
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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

  • Minty7's avatar
    Minty7
    New Member
    8 years ago
    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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • Minty7's avatar
        Minty7
        New Member
        8 years ago

        It wroks, thank you!