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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ukeasyproj
Helper II
Helper II

I would like to create a bar graph with a target line

temp.PNG

 

what I would like is for that 80% line to go across the chart in a straight line, but instead its doing something else even though the percentage value is there

 

any idea what is going on

1 ACCEPTED SOLUTION
dedelman_clng
Community Champion
Community Champion

Use a standard column chart and use the "Analytics" pane to add a constant line

 

constant line.PNG

View solution in original post

9 REPLIES 9
Tijazz
New Member

For other users that will be having this same issue.

The solution is for you to turn off the "Show Secondary" under the Y axis

Tijazz_0-1637918471273.png

expand the Y axis, and scroll down

 

Tijazz_1-1637918785496.png

 

Then, turn off the "Show Secondary" . That's all

Ilona
Frequent Visitor

I created a measure ike this "TAT KPI = 10" for the KPI that i needed to be visible.

and it looks like a straight line "line and clustered column chart" where Analytics page is not available.

standard bar chart wasn't it for me.

 

kpi line in pbi.JPG

 

dedelman_clng
Community Champion
Community Champion

Use a standard column chart and use the "Analytics" pane to add a constant line

 

constant line.PNG

Anonymous
Not applicable

Brilliant! Why is the Analytics pane not more widely documented? I have been using Power BI for 3 years now and this is the first time I have seen an article when it is useful for me. No more... This will be in my toolbag from now on

Anonymous
Not applicable

Thank you.  This is EXACTLY what I needed. This has driven me nuts for days, and all that time it was sitting in the analytica tab (how intuitive of microsoft to put it there ! )

How can i Create that line graph above the bar graph like this arrticle. 

@jimmy09 For other users that will be having this same issue.

The solution is for you to turn off the "Show Secondary" under the Y axis

Tijazz_0-1637918471273.png

expand the Y axis, and scroll down

 

Tijazz_1-1637918785496.png

 

Then, turn off the "Show Secondary" . That's all

Anonymous
Not applicable

@jimmy09 Not sure if you figured it out. To create that chart you have to use the line and clustered column chart. 

Agree with dedelman_clng. A constant line through "Analytics" Pane would be a solution here. 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors