This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
hi
I mean is not like that, because the number for target is different every month. so I want to display the actual in the form of a bar (column) and the target in the form of a line
Hello,
With a"Stacked column chart"
Go to the "Analytic Pane" and then you will be able to set a constant line
And get the line you want
here detail picture, line-black is target, bar (column) is actual.
-----------------------------------------------------------------
i can create like this but line for target can't long like picture above.
you can use mixed visual stacked bar graph and linechart
set markers as lines
and reduce the line thickness to zero
the result is something like this
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.