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 o...
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
I'm not using a measure. It's a Direct Query so I'm just linking right to the date in our CRM database.
Anonymous you can create a measure and then add 0 to it as mentioned previously.