Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power bi query

I want to show items with no data as 0 instead of blanks.   In the above table, the category "Archived" has no related records, so it is showing as blank, is there any way to show 0 instead
Need Help
Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Anonymous ,

 

I don't see Archived category in the screenshot above. There could be many reasons why this is not appearing here.

You will have to add more details here like:

  • what columns are you moving in your visual?
  • Is there some kind of filtering on the visual which is not showing Archived in the visual?
  • Is Archived category present in your source data that you are pulling in Power BI? Share some screenshot for this.

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Pragati,

     

    Thanks for your reply.

     

    sorry it is not Archived, it is Archival & Retained.

    Yes, I have applied some filters that's why it is not showing Archival & Retained in the visual and yes this category present in the source data that I am pulling in Power BI.

     

    As you can see, now I have removed filter and it is showing the category Archival & Retained. But I want to display zero in place of blank.

     

     

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      Hi Anonymous ,

       

      If there is a filter on the visual which eliminates that category then it won't be displayed.

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Pragati,

         

        Thanks again.

         

        What would be the query if I do not keep any filter?