Mirella on 06 Jul 2018 01:45:17
Option to display as zero or blank in matrix and tables
- Comments (6)
RE: Option to display as zero or blank in matrix and tables
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.).
RE: Option to display as zero or blank in matrix and tables
Much needed - Excel PivotTables can do this with a checkbox, so why can't a Power BI matrix?
RE: Option to display as zero or blank in matrix and tables
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.
RE: Option to display as zero or blank in matrix and tables
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.
RE: Option to display as zero or blank in matrix and tables
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.
RE: Option to display as zero or blank in matrix and tables
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.