Forum Discussion
Solved
How to hide Code and show Name only in Axis?
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?
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.
Thank You khader312
But if i connect data from CUBE live connect, which i cannot create new column or new measure?