Forum Discussion

suwipach's avatar
suwipach
Regular Visitor
8 years ago
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? 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi suwipach,

     

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

     

    Best Regards!

    Dale

3 Replies

  • Omega's avatar
    Omega
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    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's avatar
      suwipach
      Regular Visitor
      8 years ago

      Thank You khader312

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

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi suwipach,

         

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

         

        Best Regards!

        Dale