Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
rsbin
Super User
Super User

OK VIZ Bullet Chart - Placement of data labels

Good Afternoon,

 

I have created the following visual using the OK Viz bullet chart.

rsbin_0-1643827628404.jpeg

I don’t see an option to place the labels either “inside end” or outside.  With the second bar, the label is placed inside, but then becomes difficult to read with the black font.

If I use a lighter colour, then the other labels become difficult to read.

 

Reaching out to the Community for suggestions on how to handle this situation.  I am using our Company colour template so changing the bar colour is not really an option at this point.

 

Edit:  Adding @AllisonKennedy  based on her response in another thread.  Allison....any thoughts or suggestions?

 

Thanks and Kind Regards,

2 ACCEPTED SOLUTIONS

@rsbin Yes, that does explain a bit, you could try Charticulator or Deneb to get the custom formatting you're after, but with that OKviz bullet chart I don't know a way to solve your problem.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

@AllisonKennedy,

I attempted using Charticulator a while back to try to create a custom stacked and clustered column chart.  Unfortunately, couldn't get very far with it.

Can you recommend a source that would be able to get me started and I can give it another shot?

View solution in original post

7 REPLIES 7
Mayank_Yavda
Resolver II
Resolver II

Hi @rsbin ,

 

Here is Bullet Chart with Custom Label Placement this will help you to get custom placed data label be it inside (End, Middle or start of Bar) or Outside of Bar.

 

Bullet Chart with Custom Data Label Placement, PBIVizEdit.comBullet Chart with Custom Data Label Placement, PBIVizEdit.comBullet Chart with Custom Data Label Placement, PBIVizEdit.comBullet Chart with Custom Data Label Placement, PBIVizEdit.com

 

 

 

 

 

 

 

 

Download link for the custom visual file in this page,

https://pbivizedit.com/gallery/bullet-chart-with-custom-label-placement 

 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  • anyone, irrespective of technical skills, can create their own visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

 

Thanks,
Team PBIVizEdit

@Mayank_Yavda,

Thank you much for the reply.  I will look into your option - not sure if I will have time in my schedule today, but will try it when I get the chance.

Thanks again and best regards,

AllisonKennedy
Super User
Super User

@rsbin Sorry for the silly question, but what's the reason for using the bullet chart and not the built in bar chart that allows you to choose label position? I can't tell from your screenshot how you're using the targets/comparison values.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy,

Thanks for taking the time to reply.  Each bar is a separate measure.  If using the built-in clustered bar chart, it does not give me the proper separation between each measure.  For consistency on the page, I do have other charts that use the targets and although not shown, I do plan on using the "States" option the bullet chart provides.  Hope this explains the method behind my madness.

Kind Regards,

@rsbin Yes, that does explain a bit, you could try Charticulator or Deneb to get the custom formatting you're after, but with that OKviz bullet chart I don't know a way to solve your problem.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy,

I attempted using Charticulator a while back to try to create a custom stacked and clustered column chart.  Unfortunately, couldn't get very far with it.

Can you recommend a source that would be able to get me started and I can give it another shot?

@rsbin I can't find the blog I found most helpful and don't recall who wrote it, but one of the aha moments for me with charticulator was understanding the difference between using the Data Axis and not. These posts may help scaffold your learning of it a bit: Charticulator - Page 2 of 2 - Burningsuit


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.