Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
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
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
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |