Forum Discussion
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...
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 )
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.
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 )