Forum Discussion
Hide blank values in table
Hi Community! I have a table of 3 columns. I don't want to show rows that have the last column blank. I did not selecteed "Show items with no data": Also I tried using the page level filter,...
Somehow, the data that were shown as blank in the Power BI desktop were transformed to 0 in the service.
I edited the filters in the service report, filtering out the 0, and it was solved.
Thanks!
If it would be something else (for example NULL), it should appear in the filter, not? but in the filter there only option that is not a value is blank.
HI Anonymous
Check the data filed, you can trim it and clean it in query editor, this should do the trick.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.