Forum Discussion

aflintdepm's avatar
aflintdepm
Helper III
2 years ago

Paginated Report Removing Rows with Blank Balance

I have a paginated report that I have created in a workspace.  The data is a list of patients with and without outstanding balances.  When I created the report, I did not apply any filters for balanc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi aflintdepm ,

Regarding your question, I've assumed some data:

1.Power BI desktop automatically aggregates data of numeric type, in the figure the sum function is used, the function automatically ignores 'null' values.

2.Please do the following:

3.Final output

 

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aflintdepm's avatar
aflintdepm
Helper III
2 years ago

Anonymous Please forgive my misunderstanding.  Your example is showing a table visual in PBI Desktop, correct?  When I create a such a visual, I get the results I am looking for, with empty values where there is no known balance (highlighted example)

 

However, once I upload my report into a workspace, I want to build a paginated report with the same data.  This is where I am having the problem.  The paginated report deletes all rows where this value is empty, but I want to maintain the data as it appears in the visual.  This is the result when I filter the paginated for blank

 

If I don't sum the balances, then I'm not reporting the appropriate information, so I'n not sure how changing that setting will help.