Why is it still like this using Power BI?

[Petja]

Just doesn't feel like the user experience is getting any better after how many years in development

[v-prasare]

Hi @Petja,

As we haven't heard back from you, we would like you to please share the sample PBIX file shown above? This will help in understanding your scenario and providing an accurate solution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[v-prasare]

As we haven't heard back from you, we would like you to please share the sample PBIX file shown above? This will help in understanding your scenario and providing an accurate solution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[IrinaTokm]

Hi,
As far as I know, the standard clustered bar chart still does not let you control the distance between the bar and the data label. When you turn on the detail label with the arrow, the arrow is always placed right after the value, so part of the label stays over the bar.

One workaround is to turn off the detail label and create a measure that already combines the value and the arrow, for example:

Delta label =
VAR v = [Your value]
VAR d = [Your delta]
RETURN
FORMAT(v, "#,0") &
IF(d > 0, " ▲", IF(d < 0, " ▼", ""))

Then use this measure as the value for the data labels and set Data label position to Outside end. In this case the whole text (for example 4603 ▲) is treated as one label and is placed completely outside the bar.

For full control of labels you would still need a custom visual such as Deneb or Charticulator.

[IrinaTokm]

Hi,
As far as I know, the standard clustered bar chart still does not let you control the distance between the bar and the data label. When you turn on the detail label with the arrow, the arrow is always placed right after the value, so part of the label stays over the bar.

One workaround is to turn off the detail label and create a measure that already combines the value and the arrow, for example:

Delta label =
VAR v = [Your value]
VAR d = [Your delta]
RETURN
FORMAT(v, "#,0") &
IF(d > 0, " ▲", IF(d < 0, " ▼", ""))

Then use this measure as the value for the data labels and set Data label position to Outside end. In this case the whole text (for example 4603 ▲) is treated as one label and is placed completely outside the bar.

For full control of labels you would still need a custom visual such as Deneb or Charticulator.

[amitchandak · Accepted solution]

@Petja , I did try a few combinations. Seems like Outside end, Start Overlapping, and do not reduce chart even if there is space, also we do not have an option to allocate that 

Auto seems a better option. Also, a custom label, we need to work on the label measure or the detailed measure. But I think that is true in the case of other tools too 

But we can vote for the Idea 

[Anand24]

Hi @Petja,
AFAIK, I'm afraid that this still is an issue with Power BI visual itself.

The max you can do it Data Label Position = Outside End and use smallest font size.

You can also put this as an idea here. Hopefully, it will get upvoted and there will be a feature for resolving this in future releases.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Petja]

Hi,

Thanks for the suggestion but I have little faith in the "ideas" section as many of the top voted ideas are from like year 2014 even though they are what I'd consider very basic features.

[AntoineW]

Have you tried to adjust the size of the visual or if you are limited, you can adjust the size of the report page.

Hope it can help you!

[Petja]

Hi, only the bars grow larger when making the visual bigger. The relation between bar and the data label stays the same.

[AntoineW]

Thanks for your reply, have you tested to change the data points labels so that it is located at the edge of the bar, in the center, or on the left.

Here a video to help you : https://www.youtube.com/watch?v=gyOKFSVYEew

Hope it can help you!

Best regards,

Antoine

[Petja]

Hi,

Yes I've forced them to outside end.

[Pragati11]

Hi @Petja 

can you share your query as I am not what all things you want to point out on this visual?

you can always go to formatting and modify view accordingly for your visual.

[Petja]

Well rather obviously I'd like the data label to NOT go over the bar. It's not possible to modify and the detail (the arrow) causes this. I know I could probably add a measure with some blank spaces before the value but I'm really tired of hacking every single thing on this software.

[Pragati11]

Hi @Petja 

I suggest trying some formatting options like padding.

[Petja]

Hi,

I definitely would if those were available for clustered bar charts 🙂