Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |