Skip to main content

Power BI

Needs Votes

Data Label Alias

Vote (145) Share
Maz's profile image

Maz on 20 Jan 2016 09:53:08

It would be very beneficial to be able to create "aliases" for data labels, without having to change the actual data values. Aka a shortcode for long names. As we dont have the ability to move/edit the labels themselves. Eg: A pie chart with a long name gets cut off, and if there is the same prefix, then both the legend and the label are useless.

Comments (10)
Maz's profile image Profile Picture

5f3697db d357-40be-8369-9fbda59f3d64 on 06 Jul 2020 00:12:22

RE: Data Label Alias

Quick and easy way - I had a value of 0 or 1 and I wanted a value of No or Yes. Create a group, one value per group, and use that rather than the value field itself.

Maz's profile image Profile Picture

de04953f a649-42cb-8a73-60003181cded on 06 Jul 2020 00:06:55

RE: Data Label Alias

Yes, it will be very helpful ! I see this post started on 2016 till now still no change.
Also the height of the column header, it is basic that can change it

Maz's profile image Profile Picture

8ab7af29 1974-43c8-b207-b69403497c1d on 05 Jul 2020 23:25:36

RE: Data Label Alias

It's basic! :)

Maz's profile image Profile Picture

ce9ba3e8 3bbb-4e23-90e6-60f92e6e5b3a on 05 Jul 2020 23:06:06

RE: Data Label Alias

would be very usefull to have.
also would be usefull so conditional formatting could be done on text which could then be in the alias version a number (now a workaround)

Maz's profile image Profile Picture

49b77636 886b-49df-a45d-62f973d15f5a on 05 Jul 2020 22:47:17

RE: Data Label Alias

You can fake it, sort of, for field or calculated columns using the Hierarchy. Create a new hierarchy and move the field or calculated columns into the hierarchy. If you rename the field in the hierarchy it wont change the original field name. It doesn't work for calculated measures. Even though you cant drag a hierarchy into a value field for a chart you can drag the renamed field from the hierarchy and the legend will read those names.

So far i haven't found a snag but i just started to do it today.

Maz's profile image Profile Picture

8aea17a1 69d6-4568-8147-79b7452cbd7c on 05 Jul 2020 22:46:06

RE: Data Label Alias

Also if we can use this for the address in the map function, because having the full address takes up precious real estate on the tool tip icon. Aka having the ability to alias 7525 166th Ave NE, Redmond, WA 98052 as Microsoft would be very useful

Maz's profile image Profile Picture

c887da6b 9d04-489c-8af0-276c066bdcba on 05 Jul 2020 22:37:05

RE: Data Label Alias

It will be also useful if we can adjust the height of the column header

Maz's profile image Profile Picture

b92f42b6 2f44-45e5-bdcb-6f384a23cb98 on 05 Jul 2020 22:35:24

RE: Data Label Alias

'+1

Maz's profile image Profile Picture

53848ae2 04e4-4eed-87ea-0ab46734f1b1 on 05 Jul 2020 22:35:19

RE: Data Label Alias

This would be very useful - better control of report presentation.

Maz's profile image Profile Picture

464e2f60 e0a3-48c1-bd12-e057d5623599 on 05 Jul 2020 22:35:05

RE: Data Label Alias

I agree, especially when you do a max or median turn the name into "Max of Sales" which is very ugly and long