Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.