How to display is in report?

[heathernicole]

Creating a report for commission.

Using the Matrix visual. I need to display a 0 for values that have a 0. In the dataset it displays as 0 but it won't in the visual. Any ideas?

[Nhallquist]

The first thing we should try would be to make sure you have the setting set where it allows the Row to show all items, even those "with no data.  

try this and let us know if that worked or not.

Nate

[heathernicole]

I did do that - it helped, it gave it a space. Which will work but ideally there are some cases where a 0 needs to be visible on the report side. It's on the backend, in the dataset. 

[Nhallquist]

Since you got spaces, This leads me to believe that those values are blank or numm.  I would do a new column and created a statement like this....

IF(ISBLANK(myfield), 0,

    IF(LEN(myfield)=0,0, myfield))

No promises that this is the exact syntax, my DAX is really rusty.  However, the goal is to check if the field is "blank".  If it is, place a zero, then next test to see if the length of the field is zero characters.  If it is, then a zero, else the value of your field.

Let me know if this nets you the results you are looking for.

Good Luck,

Nate