Forum Discussion
Advocate IIWhy is it still like this using Power BI?
Just doesn't feel like the user experience is getting any better after how many years in development
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 tooBut we can vote for the Idea
15 Replies
- Anand24
Super User
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
PetjaHi,
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.
- 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.
- 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
- amitchandak
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 tooBut we can vote for the Idea
- IrinaTokm
Advocate I
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.
- v-prasare
Community Support
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
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
