cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Akshaya Member
Member

Matrix visual

If my matrix visuals has certain columns that do not have values, then how do I show them as zero?

 

Thank You!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Matrix visual

In your calculated measure/ column formula. Just add +0 in the end.

 

Thanks
Raj

Super User
Super User

Re: Matrix visual

Hi @Akshaya

 

 I think you are pulling ID from table and setting count in the "Fields" Tab. Instead, i would recommend to create a measure COUNT(Table1[ID]) +0 and use it in the matrix , which is the best practice so that it will help you in any futue measure branching as well.

 

Thanks
Raj

6 REPLIES 6
Super User
Super User

Re: Matrix visual

Use Column+0 in formula.

 

Thanks
Raj

Akshaya Member
Member

Re: Matrix visual

@rajendran Hey where to give that?

Super User
Super User

Re: Matrix visual

In your calculated measure/ column formula. Just add +0 in the end.

 

Thanks
Raj

Akshaya Member
Member

Re: Matrix visual

@rajendran Hey that worked for the measures. But how can I show them with I have taken say Count of ID'S directly from the table?

Super User
Super User

Re: Matrix visual

Hi @Akshaya

 

 I think you are pulling ID from table and setting count in the "Fields" Tab. Instead, i would recommend to create a measure COUNT(Table1[ID]) +0 and use it in the matrix , which is the best practice so that it will help you in any futue measure branching as well.

 

Thanks
Raj

Akshaya Member
Member

Re: Matrix visual

@rajendran It worked. Thank you!