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
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi v-frfei-msft,

        I can't do that either, so guess I will have to wait until we have the tabular model ready.. :smileysad: