How create a stacked bar chart 100% completion Line?

Hi sahooak ,

Thanks for sharing the details and the screenshot. I tried to recreate the setup using a sample dataset with the same field structure, and the visual appears to behave as expected. The combination of a stacked column and a line chart works correctly when using one measure on the column axis Sum of ShipmentValue and multiple measures on the line axis Target 100% and Shipment %, with Category on the shared axis and Status on the legend.

If you’re seeing a mismatch, missing line, or label overlap, it might be due to how the data types or aggregation levels are set up. It’s worth checking that both Target 100% and Shipment % are formatted consistently as decimal or percentage values and that the secondary axis is properly scaled. You could also try removing and re-adding one of the measures to refresh the visual binding, as Power BI occasionally holds onto an old field reference when visuals are edited multiple times.

If the issue still persists after confirming those settings, please share a brief description of the behavior you’re seeing for example, whether the line disappears, the scale is incorrect, or data labels overlap. That will help determine whether this is a reproducible product issue or something related to the underlying data model.

This is the answer I am providing. Can you please validate if this workaround is working properly for you? Let me know if you have any other queries

Please find the attached PBIX and Screenshort file for your reference.

Best Regards,
Tejaswi.
Community Support