cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Applicable88
Advocate II
Advocate II

Show blank as zero without extra measure/ utilizing the default visualisation aggregation selections

Hello,

I'm using a matrix with a dimension as rows:

 CountsPosition TotalRevenue
Post    
Direct503 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. 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

AlexisOlson
Memorable Member
Memorable Member

Nope. Blanks and zeros are not the same. You'll need measure(s) to do the conversion.

jdbuchanan71
Super User II
Super User II

@Applicable88 

No, it is not possible to show 0 instead of blank using the default aggregations.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors