cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User II
Super User II

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

 

constant line.PNG




Proud to be a Super User!




View solution in original post

5 REPLIES 5
Regular 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

 

Super User II
Super User II

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

 

constant line.PNG




Proud to be a Super User!




View solution in original post

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

@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
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors