Show items with no data on new update

[jamal29]

Hi all,

On the previous update, to show items with no data, we simply had to go to the viz pane, click the arrow on the field and select 'Show items with no data'.

The problem I have is that there is no option for this on the latest version and I need to show all the line items on a table even if it doesn't have values without adding IF and IFBLANK DAX onto my measures.

[v-shex-msft]

HI @jamal29,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

For example:
The version of power bi desktop that you tested. Power bi desktop or power bi report service optimate version? The Visual type and detail operation steps to reproduce this issue.

Regards,

Xiaoxin Sheng

[Anonymous]

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

[jamal29]

Hi but I have already seen this page. This only shows the previous Power BI version and excludes the newer version.

[Anonymous]

'By default, Power BI will not show items with no data in a chart. However, you can change this behavior and display items with no data in the "Format" tab in the Visualizations pane. You need to expand the "X-Axis"  section.Look for the "Include empty categories" option and turn it on by toggling the switch to the right.'

show items with no data - Microsoft Fabric Community

[jamal29]

I am working on a table so there is no x axis, however i converted it to a chart and I don't see the 'Include empty categories' option.
None the less i have to use a TABLE/ MATRIX TABLE as I am creating financial statements.

[Anonymous · Accepted solution]

You would then have to create a DAX measure to test if selected attribute related to value has no value. We have used this for a SUM:

ValueNoValue SUMx = SUMX( 'TableName', Sum( TableName[ColumnToSum] ) + 0 )