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 ther...
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 )
  • 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

        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.