Visual To Display Data Counts When Count Is 0

[Anonymous]

Hello!

I am working on a report that displays sales rep activities for the current week. The report is being displayed on a monitor in the sales department. As you can imagine, at the beginning of the week, there will be no activity recorded. Our sales managers would like a way to display all rep names with a "0" for activity. Right now it looks like this:

Is there a different graphic or a way to tell this graphic to display rep's that have no activity with a 0 count?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Actually, you can only display existed records.(e.g. records with blank amount) If this record not really exist in your table, you can't direct display it.
You need to use other table field(with relationship) as axis and write formula based that table fields.

Display zero instead of blank in matrix

Regards,

Xiaoxin Sheng

[parry2k]

@Anonymous whatever measure you are using , add 0 to it

my Measure = SUM( Table[Amount] ) + 0

[Anonymous]

I'm not using a measure. It's a Direct Query so I'm just linking right to the date in our CRM database.

[parry2k]

@Anonymous you can create a measure and then add 0 to it as mentioned previously.