Forum Discussion
Creating a SSRS report into Power BI report builder (Paginated Report)
- 1 year ago
Power BI Report Builder (like SSRS) does not natively support true chart overlaying like in layered visuals, but you can simulate overlays using careful alignment and transparency.
1. Use a Rectangle as a Container:
- Insert a Rectangle to group the charts.
- Place all three charts inside it — this ensures they move and align together.
2. Set Chart Backgrounds to Transparent:
- For Chart 2 and Chart 3 (timestamp and event marker), set:
- Background Color: Transparent
- Chart Area Border: None
- Plot Area Border: None
3. Align Charts Precisely:
- Use the Properties pane to set identical position (Top, Left) and size (Height, Width) for all charts.
- Set Z-Index to control layering (Chart 1 = base, Chart 2 = middle, Chart 3 = top).
4. Axis Management:
- Keep axes only on Chart 1. Hide axes, labels, and legends for Charts 2 and 3 to avoid duplication.
This mimics overlay behavior and preserves SSRS-style visuals. It’s a manual approach but works reliably with precision placement.
If this helped solve or clarify your issue, please mark as solution and give kudos.
Power BI Report Builder (like SSRS) does not natively support true chart overlaying like in layered visuals, but you can simulate overlays using careful alignment and transparency.
1. Use a Rectangle as a Container:
- Insert a Rectangle to group the charts.
- Place all three charts inside it — this ensures they move and align together.
2. Set Chart Backgrounds to Transparent:
- For Chart 2 and Chart 3 (timestamp and event marker), set:
- Background Color: Transparent
- Chart Area Border: None
- Plot Area Border: None
3. Align Charts Precisely:
- Use the Properties pane to set identical position (Top, Left) and size (Height, Width) for all charts.
- Set Z-Index to control layering (Chart 1 = base, Chart 2 = middle, Chart 3 = top).
4. Axis Management:
- Keep axes only on Chart 1. Hide axes, labels, and legends for Charts 2 and 3 to avoid duplication.
This mimics overlay behavior and preserves SSRS-style visuals. It’s a manual approach but works reliably with precision placement.
If this helped solve or clarify your issue, please mark as solution and give kudos.