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?
Go to Solution.
I'm afraid this isn't supported by now. Please submit an idea here if you want this feature.
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?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.