Bars&line chart without displaying the line (but still need the data labels)

[Anonymous]

Dear fellows,

I am working with a bars&line chart but I would need to NOT show the line itself - since it gives the impression of a trend, which is not my case.

I would like to keep the related data labels though, and have them showing up next to each of the bars (they represent a % growth of each of the bars which exress an absolute growth).

In an excel chart, I would just use the 'no line' option in the format options to achieve this.

Is it possible to do the same here, with this or maybe another visual?

It looks like no to me, but would be glad to hear otherwise.

Thank you!

[ivostammis]

It is kind of a cheat, but if I understand your question correctly, then yes it is possible.

Just make sure to set the line width (stroke) to 0 in the shapes section when you have the bar/line chart selected! That way you will still see the labels visible

[Anonymous]

Thanks,

that helps indeed !

The only thing is that it's not possible to move data labels around - they still follow the 'pattern' of the (now invisible) line, therefore can be confusing. But I think this is as closest as I would get to what I need...

Thanks

[ivostammis · Accepted solution]

The only solution to position the labels would be change chart type, whether that helps you will depend on your needs on visual design of the chart.

If you create a clustered bar chart, with the data you used on the line previously, set as second bar series, you can:

- Set the color of that second bar to the color of the background (Data colors -> 2nd value)

- Set the data labels voor the second bar to the right position, with the right color (Data labels -> Customize series -> Value 2 -> Postion: = inside base.

- You may want to hide the legend to prevent confusion about the missing line

This would give something like this:

Hope that helps!

[Anonymous]

Hello, Is it possible to show several barcharts in a single powerbi custom visual?
I've a requirement that must show several bar graphs in the same visual custom, they are metrics connected to each other.
For example:
Chart A --> Chart B
|
Chart D --> Chart E --> Chart Z

Please let me know your comments. Thank You.