Table visual to show zeros/blank values

[billyrich83]

Hi I'm trying to create a table vidual in Power Bi to help track numerous kpis for our project. It's things like late doucments, late invoices, number of actions and num,ber of tasks. 

I need the tablke to show blank or 0 results and not filter these out of the table is the a simple way to do this? 

I'm currently playing about and using slicers but its going to get messy. 

see screen shot below let me know if you nmeed a copy of the report as  I will need to edit as due to some of the information being sensitvie. 

Thanks 

[v-jianboli-msft · Accepted solution]

Hi @billyrich83 ,

Power BI lets you visualize data from various sources. When you create a visual, Power BI only shows relevant data to properly manage how data is presented and displayed. Power BI determines which data is relevant based on the configuration of the visual and the underlying data model. However, there may be times when you want to show items with no data.

The Show items with no data feature lets you include data rows and columns that don't contain measure data (blank measure values).

For more details, please refer to:

Show items with no data in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

The measure should be as follows:

Measure = coalesce([your measure],0)

Hope this helps.

[v-jianboli-msft · Accepted solution]

Hi @billyrich83 ,

Power BI lets you visualize data from various sources. When you create a visual, Power BI only shows relevant data to properly manage how data is presented and displayed. Power BI determines which data is relevant based on the configuration of the visual and the underlying data model. However, there may be times when you want to show items with no data.

The Show items with no data feature lets you include data rows and columns that don't contain measure data (blank measure values).

For more details, please refer to:

Show items with no data in Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.