Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Show items with no data on new update

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 )

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        '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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI Anonymous,

    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