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
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?