Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Remove multiple letters from data label

I have tried endless times to remove letters from unit in a regular bar chart and I can't seem to find a solution - it is freak*** annoying! This is Danish btw., but I seem to have the issue with eng...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Did you try to set the option to None?

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-frfei-msft, 

Tried that, but the data is shown in kilogram - I want to show data labels in tons, which is why I choose "Thousands", but I don't want the text afterward.

Instead, I just insert a text-box in the top, explaining that all data shown is in tons! 

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    Maybe you can try to create a new calculated column to work on it.

     

    Tons = table[your column]/1000

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-frfei-msft,

      To my knowledge that is not possible when you work with an OLAP live cube connection, I miss a lot of flexibility! 

       

      We are working on a tabular model, which allows me to do new calculated fields, but as long as we're working with the current connection, that's not an option (at least to my knowledge!).


      Thank you anyway, Frank! 

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Anonymous,

         

        How about creating a measure instead of calculated column?

         

        Regards,

        Frank