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?