cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarcoNeukom Frequent Visitor
Frequent Visitor

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

6 REPLIES 6
Community Support Team
Community Support Team

Re: Remove multiple letters from data label

Hi @MarcoNeukom,

 

Did you try to set the option to None?

data.PNG

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarcoNeukom Frequent Visitor
Frequent Visitor

Re: Remove multiple letters from data label

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! 

Community Support Team
Community Support Team

Re: Remove multiple letters from data label

Hi @MarcoNeukom,

 

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

 

Tons = table[your column]/1000

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarcoNeukom Frequent Visitor
Frequent Visitor

Re: Remove multiple letters from data label

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! 

Community Support Team
Community Support Team

Re: Remove multiple letters from data label

Hi @MarcoNeukom,

 

How about creating a measure instead of calculated column?

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MarcoNeukom Frequent Visitor
Frequent Visitor

Re: Remove multiple letters from data label

Hi @v-frfei-msft,

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