Option to display as zero or blank in matrix and tables

[mrodr0671]

Option to display as zero or blank in matrix and tables

[armallic]

this is a nice feature to have on all visuals. I would recommend to have both options, 1) show all zeros to blanks 2) all blanks as zeros. Also, would be super useful to provide this option in the Format blade.

[kenl235]

Yes this would be very nice to have and would prevent unnecessary work arounds like creating special a measure to + 0 to values to just to return 0. Pivot tables have this option in excel and it is really needed in the matrix table which essentially is a pivot table. Again I can't preach this enough as users really want similar features/options that have been developed in excel available. Many of our users won't use power bi for this reason as key functionality is lacking leaving users to develop DAX formula workarounds, which scare away the general user.

[pbiideas1]

I would also like to see the option to display blanks as actual blank spaces in other visuals, like cards, instead of showing (Blank). I currently have reports with 3 versions of metrics, one that returns blank, one that returns 0 if blank and one that returns " " if blank.

[daniel_jeremy1]

This is very needed! It just creates extra, unnecessary work having to create measures with a +0 in order to default the values to be 0.

[richard_obrien1]

Much needed - Excel PivotTables can do this with a checkbox, so why can't a Power BI matrix?

[rsmithman]

I'd love an alternative to creating extra measures for tables.

Measure 1 = SUM([myvalue])

Measure 2 = IF(ISBLANK([Measure 1]), 0, [Measure 1])

If I could just add "Measure 1" to a table/matrix, and then in Field Formatting if I had an option for that field to display blanks as [enter value], that would be great, where [enter value] is a user-defined value (zero, dash, blank, etc.).