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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.