This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. 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.