cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MarcoNeukom Helper I
Helper I

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

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 others find it more quickly.
MarcoNeukom Helper I
Helper I

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

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 others find it more quickly.
MarcoNeukom Helper I
Helper I

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

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 others find it more quickly.
MarcoNeukom Helper I
Helper I

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 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.