cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stevenrizado
Frequent Visitor

Clustered & Line Column Chart - Line value does not align with actual value

Hi everyone,

 

So I've been learning my way through Power BI using trial & error, and I've created a Line & Clustered Column Chart in order to show the absence frequencies per month per business unit. That wasn't much of an issue. I edited queries to make sure the values correspond correctly (although I get decimal numbers instead of percentages, but that's less important).

 

Next I inserted a line value, which is the norm value. This should show the maximally accepted absence percentage on a given business unit. As to be seen on the red line below, the data numbers are correct, however the representation in the chart is not. 

 

I could be wrong, but it looks like the Line value is using it's 'own' kind of Y-axis. Can anyone help me to fix this? In case necessary, the query for this chart is provided below.

 

Thanks!

Stefan

 

1 ACCEPTED SOLUTION
ValentinBIA
Resolver I
Resolver I

Hi @Stevenrizado,

 

When you click on your Line & Clustered Column Chart. go to the Visualization pane, and then Format tab.

On the format tab expand the Y-Axis part, and there you can set a Start and an End value for your Y-Axis Column, and if you scroll a bit down, you will see that you can set a Start an End value for your Y-Axis Line aswell.

Try setting the same value for Start and End for both the Y-Axis Column and Y-Axis Line. You should get what you are looking for.

 

Hope I understood correctly your issue, and that my post will solve your problem.

 

Best,

 

Valentin

View solution in original post

5 REPLIES 5
ValentinBIA
Resolver I
Resolver I

Hi @Stevenrizado,

 

When you click on your Line & Clustered Column Chart. go to the Visualization pane, and then Format tab.

On the format tab expand the Y-Axis part, and there you can set a Start and an End value for your Y-Axis Column, and if you scroll a bit down, you will see that you can set a Start an End value for your Y-Axis Line aswell.

Try setting the same value for Start and End for both the Y-Axis Column and Y-Axis Line. You should get what you are looking for.

 

Hope I understood correctly your issue, and that my post will solve your problem.

 

Best,

 

Valentin

Hi Valentin, 

 

I am not finding formating option for Y-Axis line.  I currently set Auto for Start and End of Y-Axis(Column).  

Y-Axis lines for me are fixed values and I see some sort of spikes at some part of the chart. 

 

Not sure how to attached the snapshot to this message.  There is only option to specify the link.  Should i attached to the web and provide the link here? 

 

 

 

Hi all,

I was faced with the same issue described in this post.  I implemented Valentin's solution and that worked.  (Thanks Bro.)

 

However, I noticed a "Show Secondary" toggle on the Y-Axis formatting options.  Toggling this to off produced the desired results, without the secondary Y-axis.  

 

This seems like a much better way to go... since the desired Y-axis range is the same, a secondary Y axis is just redundant and a visual distraction, and possible confusion, for end users. 

 

Perhaps microsoft only added this toggle after Valentin posted his solution.

 

it's great solution! Thanks

Fantastic Valentin!

 

Simple, yet so effective.

 

Take care,

Stefan

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors