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