Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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?
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |