Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
Good Afternoon,
I have created the following visual using the OK Viz bullet chart.
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,
Solved! Go to Solution.
@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.
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
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?
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.
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,
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
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,
@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.
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
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.
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
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
89 | |
70 | |
66 |