Forum Discussion
Impactful IndividualPaginated Report Feasibility
can it be possible to create below table with sections ( coloured header) as shown below using paginated reports (report builder)?
powerbiexpert22
Yes, this can be made dynamic, there is no need to hard code:
We can use a grouped table or matrix. In that group header cell, set an expression like =Fields!FundManager.Value so the text updates dynamically for each manager.
3 Replies
- MohamedFowzan1
Super User
Yes, RDL is really flexible and can be used for this usecase:
- You can create tables with colored section headers in Power BI Paginated Reports (Report Builder).
- Insert unbound (static) header rows before each group or section in your table.
- Set each section header row’s background color to your desired shade via Properties.
- Merge header row cells as needed and add the section title (e.g., "Smith Capital") in bold/large text if you wish.
- Fill detail rows below each colored header as per your data.
powerbiexpert22Hi MohamedFowzan1 , will these "unbound (static) header rows" dynamicaly populate based on Fund Managers or we need to hard code?
- MohamedFowzan1
powerbiexpert22
Yes, this can be made dynamic, there is no need to hard code:
We can use a grouped table or matrix. In that group header cell, set an expression like =Fields!FundManager.Value so the text updates dynamically for each manager.