Power BI Paginated report DAX parameters showing null values as the record.

[Max_WH]

The Paginated report Dataset is created using DAX query copied from the Performance Analyzer. When creating Query Parameters for the dataset in the Query Designer, the below interface is shown. There are values in the p_Division (Product Division Label).

But when I refer to the p_Division dataset (auto-generated), the auto-generated query is below and it is showing the correct number of records but null as the value after the execution. Thus the p_Division dropdown is having null for all the records.

Please advise how to proceed as it is not showing the actual records but null value.

[v-rzhou-msft · Accepted solution]

Hi @Max_WH ,

Your calculation is based on your data model, please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

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