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 all;
I have recently started trying to use Power BI Desktop. For my first attempt I am trying to replicate a dashboard I currently have in Excel. So apologies in advance if my question or explanation is a bit simple.
I am making a stacked bar chart to show top 10 call reasons by volume. I have been able to add the visual and properly define its fields and sorting. The call reason (Y-Axis) can be something like "COOLING SYSTEM - WATER PUMP" but the chart will display something like "COOLING SYS...". The tool tip will show the full label but I want the axsis label to be full or wrapped. In order to get these to work you end up with a comicly long chart.
I have tried adjusting the font size and width but neither achieve what I want.
Any suggestions or advice is very welcome.
Solved! Go to Solution.
Hi @DSVella,
I could reproduce your issue in my local environment (Version: 2.43.4647.541 64-bit February 2017). Unfortunately, the word wrap option hasn't been applied to chart visual right now. This option is only available in chart and matrix visual now. I would suggest you submit this feature request at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas, and you can post the link back, I will vote it for you. Thanks for your understanding.
Best regards,
Yuliana Gu
There is now a "Maximum Size" slider which changes the amount of space available for Y Axis labels (using version 2.63 here)
Here is an additional solution using the Matrix visual with conditional formatting to enable more control of the y-axis labels on a simiplied bar chart. Maybe this will meet your reporting neededs: Fixing the Truncated Bar Chart
Hi @DSVella,
I could reproduce your issue in my local environment (Version: 2.43.4647.541 64-bit February 2017). Unfortunately, the word wrap option hasn't been applied to chart visual right now. This option is only available in chart and matrix visual now. I would suggest you submit this feature request at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas, and you can post the link back, I will vote it for you. Thanks for your understanding.
Best regards,
Yuliana Gu
Good morning @v-yulgu-msft
Thanks for getting back to me. I have done 2 things.
Firstly: As you suggested I have posted my idea here.
Secondly: I have found a suggestion that has be posted already to control the horizontal allocation of the space of the bar chart. This would also work. I have given it a +3.
For the moment I am going to have to put down Power BI desktop as that this is a major requirement for me and the lack of this feature is a deal breaker.
Thanks again for your help.
Hi @DSVella,
Thanks for your feedback. I have voted for both ideas from the links you provided.
Regards,
Yuliana Gu
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 |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
133 | |
110 | |
68 | |
55 |