Table visual to show zeros/blank values

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.

Hi,

The measure should be as follows:

Measure = coalesce([your measure],0)

Hope this helps.