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, not selecting Blank:

But, as you see in both screenshots, the rows with no value are still shown.
Any ideas???
Thanks!

 

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!

6 Replies

  • 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

         

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

     

    I the below is the issue its probobly " " as Space or something in your dataset

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!