Forum Discussion
Choosing a report template
- 1 year ago
Hi kylee_anne ,
Power BI does not support fully dynamic report templates that change layout based on option selections or the number of images at runtime, like a template-driven Word mail merge. However, you can achieve some dynamic behaviors using bookmarks, field parameters, conditional formatting, and DAX logic.
Options to consider:
-
Bookmarks & Selection Pane: Predefine several report layouts (templates) as bookmarks, and let users pick via buttons. Each bookmark can show/hide visuals (including different image arrangements).
-
Conditional Formatting and Visibility: Use DAX measures or SelectedValue logic to show/hide visuals or display different content/visuals based on slicer/parameter selection (including swapping images).
-
Dynamic Narratives: Use the Smart Narrative visual, and tie text to DAX measures to update content based on project selection.
-
Dynamic tables/charts: Use field parameters or dynamic measures to swap tables, Gantt charts, etc.
For images:
There’s no native way to have a visual automatically “resize” or change template for 1–4 images, but you can use multiple image visuals, each with visibility controlled by your DAX logic (show/hide based on image count).Resources:
-
Hi kylee_anne
You can create your own template, but dynamically switching between templates based on option selections isn't supported. However, you might be able to achieve a similar behaviour by using a combination of bookmarks, field parameters, and conditional formatting. Keep in mind that all relevant data regardless of user option selection must already be loaded into the semantic model.