Forum Discussion
Dynamic Headers with Multi-value Parameter
I have a report based on Departments. I need to be able to change the specific department when doing a multi-value parameter, i.e. select all option. Want to display the specific department in the header for the data displayed. It works fine if only selecting an individual department. When select all is chosen, it only displays the first department for all pages. Any assistance would be appreciated.
6 Replies
- tayloramy
Super User
Hi 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?
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.
