how is it possible to improve the look and the ease of reading of this visual?
for example, looking at it, only the first few bars are shown as they have high % but the rest on the x axis are tiny and not shown well. Although the tiny bars are still important but not easy to read as they are small counts…
perhaps (just a suggestion) some kind of horizontal line on the chart which splits the large bar and the small bars to show as taller bars? I just remember seeing something similar on a visual somewhere on the internet but can not locate it…hope this helps
@arkiboys Yes, I agree. It’s hard to read.
I would prefer adding a scroll on the X-axis.
Please try it by clicking on this visual and then got to format option and search for ‘Spacing’ (Column) and increase the Minimun Category Width to 80 or 90. (Please refer below screenshot)
Tips: You can also trying increase of decreasing Inner Padding.
You should be good to go.
Do let me know if that works for you. Thanks
I only see this and not as same as your screen-shot
@arkiboys Is it possible to share the PBIX?
not able to as it is large size and I am just learning…apologies
@arkiboys That’s fine.
Could you please confirm which chart type you are using? What are you have on the X and Y axis?
@arkiboys Got it, since you have an Integer value on the X-axis that’s why the spacing option is not available.
Alternatively, you can enable the “Zoom Slider” on the X axis which will give you more control over seeing the value.
Let me know if that works for you. Thanks
yes, I see it, but perhaps (just a suggestion) some kind of horizontal line on the chart which splits the large bar and the small bars to show as taller bars? I just remember seeing something similar on a visual somewhere on the internet but can not locate it…hope this helps
@arkiboys I think that’s small multiple.
Here’s the video link you can explore.
Do let me know if that works for you Thanks
@arkiboys Have you checked my above response yet?
carrying out analysis. Will come back to you.thank you
Not what I am after…
but perhaps (just a suggestion) some kind of horizontal line on the chart which splits the large bar and the small bars to show as taller bars? I just remember seeing something similar on a visual somewhere on the internet but can not locate it…hope this helps
Bumping this post for more visibility from our experts and users.
Can you provide more details on what you would like to achieve in your visualization so that others can also chime in with suggestions?
If there will be no more activities on this post, we will be closing this thread.
I recall a while back I saw a chart visual in SSRS which showed the vertical bars for low and high values.
Basically to have a horizontal line across the vertical bar chart which cuts short the long values and so the smaller value bars can be shown easily as well.
Hope that makes sense.
@arkiboys We don’t have this kind of chart available in Power BI (default).
Maybe you can search in the marketplace.
Do let me know if that works for you. Thanks
I was thinking about the custom visual you mentioned, but without an image to reference, I couldn’t picture it. I wondered if you are instead searching for a Data Storytelling aid. One custom visual that has been around for a while was previously showcased by Devin Knight (https://www.youtube.com/watch?v=M16VFpXFrGA) during the time when he was publishing many videos on Custom Visuals. I actually used this visual myself when needing a solution that was flexible, and an open-source project/public repository that met the business requirements.
ChartAccent - BarChart
by by Donghao Ren
Appsource URL: https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381311?exp=kyyw
Overview: A bar chart with rich annotation features for your presentation.
Annotations are very important for presenting data visualizations. ChartAccent is a tool for annotating charts. This visual enables you to create bar charts with rich annotations with a few clicks. You can highlight individual bars, a data series, bars with a range, or even bars above the average value. To learn more about ChartAccent, visit https://chartaccent.github.io/. ChartAccent is an open-source project at https://github.com/chartaccent/chartaccent
Here is a cool paper that focuses on the value of using this in Data Storytelling:
ChartAccent: Annotation for Data-Driven Storytelling (https://chartaccent.github.io/publications/chartaccent-pacificvis2017.pdf)
Check out the custom visual to see if it adds value to meet your needs.
Not quite. I will search for the SSRS visual I saw a few years ago and put it here…
thank you for looking into this.