Hi,I'm running paginated report and found it is not showing 0 or null or blank values, only valid number are showing. e.g. my data has 0 under 'Contract Amount' in dax datatable but it is not shown on paginated while it is shown on normal bi dashboard. Any resolution pls?

Your paginated report hides 0/blank because of filters or formatting. Fix:Check filter → make sure 0 is included.Handle blanks → use=IIF(IsNothing(Fields!ContractAmount.Value), 0, Fields!ContractAmount.Value)Check number format → don’t use formats that suppress zeros.(Optional) In DAX, use COALESCE([Contract Amount],0).

Getting blank or 0 values in paginated report

14 Replies

Shahid12523
Community Champion
1 year ago
Your paginated report hides 0/blank because of filters or formatting.

Fix:
Check filter → make sure 0 is included.
Handle blanks → use
=IIF(IsNothing(Fields!ContractAmount.Value), 0, Fields!ContractAmount.Value)

Check number format → don’t use formats that suppress zeros.
(Optional) In DAX, use COALESCE([Contract Amount],0).
- Anonymous
  Not applicable
  1 year ago
  Hi
  Where should I put this? in dax?
  
  Handle blanks → use
  =IIF(IsNothing(Fields!ContractAmount.Value), 0, Fields!ContractAmount.Value)
Anonymous
Not applicable
1 year ago
Hi,
I'm running paginated report and found it is not showing 0 or null or blank values, only valid number are showing.
e.g. my data has 0 under contract amount but on paginated, it is not shown.

Any resolution pls?
- rohit1991
  Super User
  1 year ago
  Hi Anonymous
  
  Could you please try below steps:
  
  In the filter pane, tick 0 and (Blanks) so they’re included.
  
  If nulls still don’t show, replace them with 0 in Power Query or use an expression like:
  
  = IIF(IsNothing(Fields!ContractAmount.Value), 0, Fields!ContractAmount.Value)
  - Anonymous
    Not applicable
    1 year ago
    Hi,
    
    There is no option to tick 0 since already not shown in data table, this is the point of this question.
    Since i'm talking about paginated report not general pulished BI dashboard, how can I use Query for paginated?
- v-ssriganesh
  Community Support
  1 year ago
  Hello Anonymous,
  
  Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
  
  Thank you.
- v-ssriganesh
  Community Support
  1 year ago
  Hello Anonymous,
  
  We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
  
  Thank you.
Anonymous
Not applicable
1 year ago
Hi Anonymous ,

Thank you Shahid12523 for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!
- Anonymous
  Not applicable
  1 year ago
  Hi Anonymous ,
  
  I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
  
  Thank you,
  
  Tejaswi.
  - Anonymous
    Not applicable
    1 year ago
    Hi Anonymous ,
    
    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
    
    Thank you.