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 nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. 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
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |