Forum Discussion

mhafeez's avatar
mhafeez
New Member
1 year ago
Solved

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 ...
  • Ilgar_Zarbali's avatar
    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.