Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
RS_Cool
New Member

Power BI Visualization

 

 

4 REPLIES 4
Anonymous
Not applicable

Hello,

 

With a"Stacked column chart"

Paulhaha_0-1715075896671.png

Go to the "Analytic Pane" and then you will be able to set a constant line 

Paulhaha_1-1715075935351.png

 

And get the line you want 

Paulhaha_2-1715075949580.png

 

 

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.

RS_Cool_1-1715094798638.png

 

you can use mixed visual stacked bar graph and linechart

gdelpuenteCinec_0-1715865062443.png

set markers as lines

gdelpuenteCinec_1-1715865080920.png

 

and reduce the line thickness to zero

gdelpuenteCinec_2-1715865092345.png


the result is something like this

gdelpuenteCinec_3-1715865133098.png

 



RS_Cool
New Member

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

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (26)