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

Accepted Solutions
Highlighted
Super User I
Super User I

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
Highlighted
Super User I
Super User I

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

Highlighted

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

Highlighted
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

 

Highlighted

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

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors