Forum Discussion
Creating a SSRS report into Power BI report builder (Paginated Report)
Hello,
I am currently recreating an SSRS report in Power BI Report Builder (paginated report). I’ve completed most of the report, but I’m running into an issue with overlaying charts.
To match the original SSRS design, I need to overlay three separate charts into a single visual:
Chart 1: The main data trend
Chart 2: The timestamp
Chart 3: The event marker
I’ve tried placing all three charts inside a rectangle to group and align them, but that hasn’t worked as expected. I’ve also tested a few other approaches but haven’t had any luck so far.
If anyone has suggestions or best practices for overlaying multiple charts in Power BI Report Builder, I’d really appreciate your help or recommendations. I can’t attach the RDL here, but I can share the XML version if needed.
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.
4 Replies
Hi mhafeez,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Ilgar_Zarbali for their prompt and helpful response.
Just following up to see if the solutions provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi mhafeez,
Just following up to see if the solution provided by community member were helpful in addressing the issue.
If the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi mhafeez,
Just following up to see if the solution provided by community member were helpful in addressing the issue.
If the response helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar- Ilgar_Zarbali
Super User
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.
