Paginated Report visual Not working With parameters

[DebbieE]

I have a paginated report based on a dataset created in power BI

the Paginated report is just a table

in Query designer I have added 2 Parameters

Dim Area   Area Name Equal [ALL] Parameter ticked

Dim Date   Month year Equal [ALL] Parameter ticked

And in Data set Properties I have reset the parameter values to the original params (ParamArea, ParamMonth) I set up for both that use a dataset to create the lists.

This all works fine in report Builder so i publish to PPU App workspace

Back to the Power BI Report. 

I have a page with a slicer for Area and a slicer for Date (Month Year) which are based on the exact things the parameters in report Builder are based on.

I add in a paginated Report page

connect to report and set parameters

ParamArea is ok. Use Default is on.

However ParamMonth is greyed out and there is an error the error hover over says 

'Select a related field to map this parameter' but its greyed out and you cant do anything with it. 

I have looked and looked and I can't see any reason why this is greyed out but the other one isnt. Does anyone have any ideas how I can start to fix this? I have googled quite a lot of documentation and I have found nothing so far

[DebbieE · Accepted solution]

great, As soon as i added this I managed to sort it out,

in the paginated report Param Area had the default values set up as well as available values with get Values from a Query

The other parameter only had available values set. I set them both up the same with default values get values from a query and its now working