How to hide Code and show Name only in Axis?

[suwipach]

If my Dimension entity has structured with code concatenated with name, for example, "B1101 - Roof", but i would like to hide code when i use it in Axis to show only "Roof". How could I do it? 

[Omega]

Create a new column in PBI that will return the Provision division name and replace provision division with the new column. 

Product Division Name = RIGHT(Table1[Product Division],LEN(Table1[Product Division])-FIND("- ",Table1[Product Division]))

Hope this helps. 

[suwipach]

Thank You khader312

But if i connect data from CUBE live connect, which i cannot create new column or new measure?

[v-jiascu-msft · Accepted solution]

Hi @suwipach,

I'm afraid this isn't supported by now. Please submit an idea here if you want this feature.

Best Regards!

Dale