Hi All,
I've got the solution.
The key to this problem is learning how to add the "ADDMISSINGITEMS" dax function to your dataset query on Paginated Reports builder.
Steps:
1. Open your paginated report, connect it to your database source and create a new dataset by selecting your columns and parameters, as usual.
2. After you have done that and your dataset query has been generated, you need to edit it by manually adding the "ADDMISSINGITEMS()" dax function to your "SUMMARIZECOLUMNS" function that has been generated automatically. You can find many videos and explanations on the internet on how to use the ADDMISSINGITEMS function.
3. (short explanation about the function) Add to the ADDMISSINGITEMS function the columns you would like to retrieve items with no data as a first argument, then paste your SUMMIRIZECOLUMNS function as a second argument, and finally add all the columns you selected in your initial query as a third argument (all those which are not measures). And magic, the problem has been solved.
Lastly, in case it helps a bit further, this is a way you can look at your new query in very rough terms:
EVALUATE ADDMISSINGITEMS(columns_to_show_null_values, SUMMIRIZECOLUMNS(....), columns_selected_in_your_query)
Best wishes.
