Skip to main content

Power BI

Completed

Change X and Y axis labels manually, similar to Excel

Vote (547) Share
Jake Carville's profile image

Jake Carville on 08 Jun 2016 20:01:23

I think you should be able to type whatever you want into the X and Y axis to make up the title for them.
This seems like a simple feature and works really well in Excel.

When I have multiple fields in a chart the axis is long and ugly, where a simple edit should be available to shorten this down.

Administrator on 05 Apr 2017 07:01:08

This feature is now available in the April release of Power BI Desktop. Learn more here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-feature-summary/ Enjoy!

Comments (37)
Jake Carville's profile image Profile Picture

d26c46f3 8807-44d3-882a-4b42740ce3f1 on 05 Jul 2020 22:39:16

RE: Change X and Y axis labels manually, similar to Excel

Need to enable this. It would really be very useful. Sometimes we want to squeeze the size of chart but unable to reduce the font size on axis example SankeyBarChart from custom visual.

Jake Carville's profile image Profile Picture

02659f10 dd99-4331-b840-1adf63ae6c5a on 05 Jul 2020 22:38:41

RE: Change X and Y axis labels manually, similar to Excel

It's annoying that you have to change the source data in order to change the axis title.

Jake Carville's profile image Profile Picture

31ef871f 58a3-486f-99cc-e5b8cbad71aa on 05 Jul 2020 22:37:04

RE: Change X and Y axis labels manually, similar to Excel

Lack of this feature swayed our company to not use PowerBi and use a competitor product instead, please do add this asap and we may consider again in the future.

Jake Carville's profile image Profile Picture

9e4c10f0 daae-4bdd-98a9-6a1231dc7e18 on 05 Jul 2020 22:35:08

RE: Change X and Y axis labels manually, similar to Excel

Completely agree with this. P BI charts definitely need to start offering at least the same amount of customization as excel.

Jake Carville's profile image Profile Picture

caeca8fa 27d5-4c3b-84e0-4e2217642ab8 on 05 Jul 2020 22:34:23

RE: Change X and Y axis labels manually, similar to Excel

This is marked as completed but I do not see an option under the X, Y axis to edit the axis title. I only see a toggle to show/hide the title. Can someone confirm if this is indeed available?

Jake Carville's profile image Profile Picture

d02ca4f9 227a-4ce9-9ba3-753fd5002b15 on 05 Jul 2020 22:34:05

RE: Change X and Y axis labels manually, similar to Excel

Looking forward to able edit Axis value format.
Current version of PowerBI do not support shows "Mmm - YY" format in the x-axis which is missed from Excel

Jake Carville's profile image Profile Picture

ab047424 7ac3-4d4f-b830-dc191b47f8c5 on 05 Jul 2020 22:33:34

RE: Change X and Y axis labels manually, similar to Excel

yes we need to get this feature added. at the moment we need to just have a floating text box to enable us to manually change the labels.

Jake Carville's profile image Profile Picture

a078867f 8c30-406b-809b-506632eaef55 on 05 Jul 2020 22:33:31

RE: Change X and Y axis labels manually, similar to Excel

Format & edit axis title as well. These are not options in Power BI, but it would be useful.

Jake Carville's profile image Profile Picture

d2985fe9 1dd2-4f30-91ae-4cf5dc3e2af6 on 05 Jul 2020 22:33:31

RE: Change X and Y axis labels manually, similar to Excel

Another update and this is still, unfortunately missing. This is a necessary change, the current method of using the variable names is completely inappropriate - axis labels should indicate units of measure, not the name of what is being measured - that is what the title and legend are for.

Jake Carville's profile image Profile Picture

3d88f0a8 41a1-4d7e-8ecb-9f099ab1e4f7 on 05 Jul 2020 22:33:26

RE: Change X and Y axis labels manually, similar to Excel

More customization please!! It would be great to be able to display both the percentage and count on the same visual. For example, 75% (115 units). Also adjusting the size of the text is necessary, we just can't see the labels on large TV's we're using to showcase our visuals!