Unable to see blank records in pivot

[Aspiring_Developer]

Hi All,

 I have below table :-

As you can see I have two records for test uat2 having different comments , one is 'testtt' which is added by user and other one is 'No input by user' which is added by me to replace blank value.

When I take the same thing in pivot table, i am unable to see the second record  of test uat:-

I don't know why it is working in one visual and not in other visualization of pivot. I have not suppressed null value for any dimension. I have checked the box 'Include null values ' for all columns.

The expression for comment is here below :-

only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} if( len(trim(COMMENT_TEXT))=0, 'No Input bu user', COMMENT_TEXT))

And for Traffic Light:-

=pick(match(only(activity_color),'error','none','success','warning'), RGB(203,67,53), RGB(247,249,249), RGB(39,174,96), RGB(243,156,18))

Can anyone please help ? 

Thank You

[stevejoyce]

Doesn't this mean you have 2 comments for "test uat2"

Only function will return a value if there is only 1 value.  

If you want to show all comments for a given cell, switch to concat()

concat({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} if( len(trim(COMMENT_TEXT))=0, 'No Input bu user', COMMENT_TEXT), ', ')