Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |