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

Seems like whatever is in the Values column is not really blank  (even though it may look like that to us). Maybe do some clean up in Power Query?  

  • 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.

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      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 Repczynski

       

    • 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