Forum Discussion
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?
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
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
It wroks, thank you!