cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nicho248
Helper II
Helper II

line and clustered column chart, line is not long enough

Hi All - 

 

This is a presentation level issue with the chart as far as I can understand. The issue is the line stops at the mid-section on both the beginning and end of the data to display. This results in bisecting the clustered columns and is weird. My current workaround is to add arbitary columns to display (which have no data) and this extends the lines but is then displayed on the x-axis.

 

Anyone have any ideas on how to resolve this or have an alternate workaround? I don't like my workaround as it confuses people (whats left & right??).

 

Chart without workaround (axis labels whited out)

Without workaroundWithout workaround

Chart with workaround (same labels whited out)

with workaroundwith workaround

1 ACCEPTED SOLUTION
dedelman_clng
Community Champion
Community Champion

Hi @Nicho248  - 

 

Is the line meant to be a constant value, or does it change depending on slicers?  If the former, you can make the visual a clustered column chart and use the Analytics feature to create a constant line.

 

If the latter, does the line have a different scale than the columns? You can use a secondary Y-axis for the line that may move the line above where most of the columns are, thereby looking less confusing.

 

You can also try to shrink the width of the columns, so that the bisection is "less" noticeable.

 

The line point is going to hit right in the center of the axis value. That's what it would do if it were a line visual only as well.  Best thing to do is to mitigate the confusion in the visual by making formatting choices. Another option, which I've done in reports, is to have two separate visuals - one the clustered column, one the line - place the line visual completely above the column visual, and then turn off the X-axis on the line visual.  You have to do some playing with overall width of the visual to get it to line up perfectly, but it's possible.

 

2020-09-03 14_23_39-Microsoft Edge.png

 

Hope this helps

David

View solution in original post

6 REPLIES 6
dedelman_clng
Community Champion
Community Champion

Hi @Nicho248  - 

 

Is the line meant to be a constant value, or does it change depending on slicers?  If the former, you can make the visual a clustered column chart and use the Analytics feature to create a constant line.

 

If the latter, does the line have a different scale than the columns? You can use a secondary Y-axis for the line that may move the line above where most of the columns are, thereby looking less confusing.

 

You can also try to shrink the width of the columns, so that the bisection is "less" noticeable.

 

The line point is going to hit right in the center of the axis value. That's what it would do if it were a line visual only as well.  Best thing to do is to mitigate the confusion in the visual by making formatting choices. Another option, which I've done in reports, is to have two separate visuals - one the clustered column, one the line - place the line visual completely above the column visual, and then turn off the X-axis on the line visual.  You have to do some playing with overall width of the visual to get it to line up perfectly, but it's possible.

 

2020-09-03 14_23_39-Microsoft Edge.png

 

Hope this helps

David

Hello David -

 

Thank you for the alternative options listed. I will check into these and advise.

 

Prior to loading into power bi, I had this simple chart working in excel no problem. Was extremely easy and the 'bisecting' issue isn't present there. Figured it was user error on my part in power bi. The graph is displaying product available, and what is required to build next in order to hit the desired safety stock level. The line is the safety stock level. So, in other words the available will vary from -200 to +200, the build next will vary between 0+ maybe 400, while the safety stock is 0 to maybe 100. In this example the safety stock is set the same for all products, but may change in the future.

 

I'll try the analytics recommendation and advise from there. Worried I may have to just attempt to stack charts or stack a line image instead.

 

N

Hi @Nicho248 -

 

One other thing to note is that if your two columns are separate measures (as opposed to a single measure split up by a field in "Legend", you could make the safety stock level a 3rd column, and put the 3 columns in an order that makes sense - not necessarily the best solution, but another "workround".  Given what you've described the purpose of the report is, narrowing the columns as much as possible on the graph would probably give you the best result without having to resort to more extreme measures.

 

David

Hi @dedelman_clng - 

 

I'm stopping at the first thing that gets me by for now. So the analytics/constant line works fine. May have issues down the road when the targets are different per product.

 

Thanks again for your help!

 

Annotation 2020-09-03 130616.png

 

N

Pragati11
Super User
Super User

Hi @Nicho248 ,

 

The reason why your line is not shown complete is due to the missing data.

I don't think there is a workaround for this, because this is the missing data issue.

 

Thanks,

Pragati

Best Regards,

Pragati Jain

MVP logoDACertAzCert

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hello Pragati -

 

I don't understand your comment. My graph has no missing data. What are you thinking is missing?

 

N

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors