Forum Discussion
Visual To Display Data Counts When Count Is 0
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?
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
4 Replies
Anonymous whatever measure you are using , add 0 to it
my Measure = SUM( Table[Amount] ) + 0
Anonymous you can create a measure and then add 0 to it as mentioned previously.
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
