Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
This hasn't fixed the issue for me. My parameter has default values set and works fine in Report Builder, but still greyed out in Power BI and not letting me map a Power BI field. I can load the report but dragging a field manually into the Parameters bucket makes no difference.
It has been published to a Premium workspace so should work correctly.
Never mind - I eventually got this working. The process isn't as clear as it initially appears. For anyone with a similar issue, you need to:
* drag your field into the Parameter bucket while on the parameter mapping screen, not once you've clicked off it to launch the report.
* then the field should be available in the dropdown.
Thanks that fixed it for me too!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
5 | |
3 | |
3 | |
2 |
User | Count |
---|---|
12 | |
11 | |
7 | |
3 | |
2 |