Remove multiple letters from data label

[Anonymous]

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 english as well.
Also, I am using an OLAP Cube connection, so I am kinda restricted. 

[v-frfei-msft]

Hi @Anonymous,

Did you try to set the option to None?

Regards,

Frank

[Anonymous]

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]

Hi @Anonymous,

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

Tons = table[your column]/1000

Regards,

Frank

[Anonymous]

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]

Hi @Anonymous,

How about creating a measure instead of calculated column?

Regards,

Frank

[Anonymous]

Hi @v-frfei-msft,

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