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 ,

 

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?