Forum Discussion

Hawkeye's avatar
Hawkeye
Frequent Visitor
9 years ago
Solved

Editing Axis Text

Hi all,

 

New to PowerBi, so apologies if a stupid question.

 

I've previously been using Tableau which offers the ability to 'Edit Alias' on the text displayed on the Axis (and change the names originally drawn from the spreadsheet) is there a similar function for Power Bi?

 

It's not a case of a mass renaming of everything, just the odd title here and there that needs shortening - would I have to change the data file to make these changes, or is there a way to do it via the Desktop app?

 

Thanks! 

  • Hi Hawkeye,

      

    As we can see from the picture, the blue square part is the title of the axis. Did you mean you want to change the name of the part in the red square? If so, more than one value (name) would be a group. So we can change its name into "group A" or something else.

    Did you mean this?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

      

    Best Regards!

    Dale

9 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Hawkeye,

     

    You can do it in the "Format" of Power BI Desktop. I guess most of the visuals have such settings.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • Hawkeye's avatar
      Hawkeye
      Frequent Visitor

      Sorry! My fault for not explaining clearly. 

       

      So, for example, my Axis is named sales, and the report that the data is drawn from has the text of (for example):

       

      • Sales Ashton, Burton, Colleridge
      • Sales Tusome, Stoke, Wigan

       

      and I'd like to shorten these on the axis to read something like:

      • Sales A - C
      • Sales T - W

       

      Edit Alias in Tableau allows you to do that for individual row items without further data editing; I was just wondering if there was similar for Power Bi, or if I'd need to use another column in the datasheet with tidied up names and use that as labels.

       

      Thanks 

       

       

      • Hawkeye's avatar
        Hawkeye
        Frequent Visitor

        Sorry to bump this - just curious as to if it's possible, or if it's something I should address in the data before importing.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    I tried this solution, but it only changes name in the Legend and not on the axis. Is this not working that way anymore or is there another way?