Forum Discussion
Dynamic Headers with Multi-value Parameter
Super UserHi Bernice,
Can you share a sample file or include screenshots of what you are after?
What visual are you using? Is this a Power BI report or a paginated report?
Generally, a table visual can only have one value in the header row, it can't support multiple values there, and the default summarization is first.
Some more details about what exactly you're trying to do would help.
Using Paginated report
Using a textbox in the header to display the Department name associated with the budget data that is in the report.
There are 14 departments that I'm trying to select all departments and have it print the departments in one lump batch, with each department having 1-3 pages per department of budget data.
Is there a recommendation of how to do this, other than selecting individual departments one by one from the parameter list and printing it off?
- tayloramy
Hi Bernice,
you would need to build the paginated report to be able to handle multiple values for department.
One way to do this is to add department in the row groups at the bottom and then the report will generate a new section for each new department.
I currently have department as my high level group, followed by fund type, group and category. Are you recommending then adding department as the lowest level, to force a new section for each department?
Paginated report
There are 14 departments that are 1-3 pages in length of budget data associated with each department. The user would like to be able to do a select all on the parameter values to select all departments, display/print out the budget data for each department.
Any suggestions would be appreciated.
