Forum Discussion
Show blank as zero without extra measure/ utilizing the default visualisation aggregation selections
Hello,
I'm using a matrix with a dimension as rows:
| Counts | Position | TotalRevenue | ||
| Post | ||||
| Direct | 50 | 3 | 1000 | |
| Total |
I know using If-statements or adding a "+0" in a count measure can solve this problem, but I try to stick with
the standard aggregation function for the tables without an extra mesaure. When PowerBi recognized it as a Number- Datatype I already have plenty of aggregation for selection. Here depending on column I used count or sum . In the row properties I already clicked that it should show also empty values. But as you see its blank instead of zero.
Is it possible without a extra measure to change it?
Thank you very much in advance.
HI Applicable88,
In fact, 'if statement' and '+0' on the expression not work to handle records that not really existed in your table.
For this scenario, you need to create a not connected to the raw table and use its fields to replace raw table categories. Then you can use Dax expression to extract the current data and compare it with if statements.Regards,
Xiaoxin Sheng
3 Replies
No, it is not possible to show 0 instead of blank using the default aggregations.
Nope. Blanks and zeros are not the same. You'll need measure(s) to do the conversion.
HI Applicable88,
In fact, 'if statement' and '+0' on the expression not work to handle records that not really existed in your table.
For this scenario, you need to create a not connected to the raw table and use its fields to replace raw table categories. Then you can use Dax expression to extract the current data and compare it with if statements.Regards,
Xiaoxin Sheng
