Constant line stacked bar chart - Value options

[Anonymous]

Hello,

I have been able to add a constant line in my horizontal stacked bar chart, but the value given for the line to note the tasks breaches is overlapping with the bar values.

I have checked the available options such as above or under the line, left or right, but it keeps showing the value beside the constant line.

In tableau, it was nicely visible outside of the bars and the bar lables vs the constant line lables would not overlap.

Appreciate if any help or ideas that anyone knows on getting the value more visible in the bar chart or to make the line look bigger (not wider) I mean the height of the line.

Thanks

[Anonymous]

@lbendlin  - this is now resolved, as I have found the solution which works. thanks for your help.

[Anonymous]

thanks @lbendlin - I have tried all the available options already, but the line height is cutting exactly at the edge of the first bar and at the bottom on the last bar. So the Constant line value that I provide manually for this gets in the middle of the last bar and it does not look good.

They should ideally allow to resize the height of the constant line and moving the value outside of the bars as that would be great presentation instead of keeping it auto fixed for both the line and the value.

I will submit this as an idea if not submitted already.

[lbendlin]

Consider using Deneb for more control over the layout.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Hi @lbendlin  - sorry for my late reply, 

I need the solution similar to the attached screenshot.

If you see the example below, the numbers (341.05) is showing outside of the top bar but in my case it shows on the bar and its confusing the users. Can you please help?

I mean the height of the line is outside of the bars both on top as well as bottom, and I need exactly same type of chart (stacked bar chart - horizontal) with a constant line.

Thanks

[lbendlin · Accepted solution]

choose "Under"