Forum Discussion
Paginated Report Line Chart – Series Color Expression Not Applying Correctly Per Legend
Hi Anusha__v , Thank you for reaching out to the Microsoft Community Forum.
This is a known limitation. In SSRS / Power BI Paginated Reports, when a line chart uses a dynamic legend (series group), colours are assigned to series instances at render time. Those instances are created and reused based on internal rendering order, not permanently bound to a specific legend value like ProductName. As a result, even correct colour expressions can appear to move between products when the data shape or render order changes. Sorting the dataset, series group or returning the colour from the dataset may not fix this, because the renderer does not maintain a stable key-to-color mapping.
If you need deterministic colours, the only reliable solution is to avoid a dynamic series group. Define one static series per product (or pivot the data so each product is its own value column) and set the colour directly on each series. This forces a one-to-one relationship between product and series and guarantees consistent legend colours. With a fully dynamic legend, there is currently no supported way in paginated reports to lock colours to specific legend values.
Hii Anusha__v
To get deterministic colors, the usual workaround is to create a separate series group per product (or per color group), or return the color from the dataset and bind it at the series group level, ensuring stable sorting. Applying the expression only at the series level without a fixed grouping will remain non-deterministic.
Hi rohit1991 ,
Color from the dataset and bind it at the series group level. Sorting is not helping still the same issue.
Hi Anusha__v , Thank you for reaching out to the Microsoft Community Forum.
This is a known limitation. In SSRS / Power BI Paginated Reports, when a line chart uses a dynamic legend (series group), colours are assigned to series instances at render time. Those instances are created and reused based on internal rendering order, not permanently bound to a specific legend value like ProductName. As a result, even correct colour expressions can appear to move between products when the data shape or render order changes. Sorting the dataset, series group or returning the colour from the dataset may not fix this, because the renderer does not maintain a stable key-to-color mapping.
If you need deterministic colours, the only reliable solution is to avoid a dynamic series group. Define one static series per product (or pivot the data so each product is its own value column) and set the colour directly on each series. This forces a one-to-one relationship between product and series and guarantees consistent legend colours. With a fully dynamic legend, there is currently no supported way in paginated reports to lock colours to specific legend values.