Power BI - Better Data Labels

[RockandGrohl]

Hi guys.

I have a requirement to display a cost comparison of a project through various project stages. Each chunk in the stacked bar chart represents one of the components of the project cost (like materials, labour, etc)

This is what I have, ghastly colours hopefully getting changed soon. This is great, but it's useless in the case of presenting as part of a pack of slides because there's no information on what the components are. In Power BI you can hover over, but it's a bit laborious.

If I add Titles or Detail to the Data Label options, it does this:

Where it now only shows the Data Labels on chunks of the stacked bar chart that are wide enough to display it.


Is there any kind of work around for this, as it's becoming quite an issue. Ideally, I'd like to wrap the text & cost to be on two different lines, but this is an ongoing request for years on PBI suggestion forms. Playing with the setting yields no result, and the text size is already as low as it can go.

I think this requires a really clever out of the box solution.

Thank you!

 

[RoryA]

I'd like to wrap the text & cost to be on two different lines

Add the cost to the Detail section and change the layout to multi-line - e.g. :

 

[RockandGrohl]

Add the cost to the Detail section and change the layout to multi-line - e.g. :
View attachment 119782

Cor blimey. Ok we get -slightly- more data, any way you can think of where I get more?

Thanks!

 

[RoryA]

Not really. In all honesty, it would be a cluttered and probably illegible mess if you did. You could simply use a legend for what they are and leave values visible on the larger chunks (since I assume people are mostly interested in those). You might even be better off changing the data source so you only show the top N values individually and everything else is other.

 

[RockandGrohl]

Not really. In all honesty, it would be a cluttered and probably illegible mess if you did. You could simply use a legend for what they are and leave values visible on the larger chunks (since I assume people are mostly interested in those). You might even be better off changing the data source so you only show the top N values individually and everything else is other.

That's pretty much the suggestions we've ended up on.

Problem is some projects end up with 20+ components so a legend becomes cluttered, and meaningless as you end up with like.. Black, slightly lighter black, even slightly lighter black, and it just doesn't help.

It's a real pickle