Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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,...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

Please check the [Value] field if there is "space" value in this "blank" value.

If you still have the problem, please share a simple pbix file for us have a test.

 

Best Regards,

Lin