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

Percent values comes with wrong decimals

Hi all,

I am facing a problem where the database I am importing contains a percentage value (average unsubscription rate for instance) and it is, let's say 1,5%

 

I am getting the value as 1,5

 

Converting that through "modeling" --> "percentage formatting" makes it: 150,0% (since 1,5 is 150 in percent). 

 

I would like either for it to understand that it already is 1,5% and thus just add a %-sign at the end, OR I would like to move the decimal to: 0,015 and then add the percentage formatting. 

 

The outcome should be that the 1,5 i have today is the actual percentage (that just lost it's %-sign) 

 

Thanks a lot

Andreas

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JoHo_BI Member
Member

Re: Percent values comes with wrong decimals

Hi Andreas,

 

Add another calculated column such as:

 

AUR = [Average Unsubscription Rate]/100

 

Put this into a percentage and you'll get the required result.

View solution in original post

4 REPLIES 4
JoHo_BI Member
Member

Re: Percent values comes with wrong decimals

Hi Andreas,

 

Add another calculated column such as:

 

AUR = [Average Unsubscription Rate]/100

 

Put this into a percentage and you'll get the required result.

View solution in original post

v-ljerr-msft Super Contributor
Super Contributor

Re: Percent values comes with wrong decimals

Hi @Ancar,

 

Have you tried the solution provided by JoHo_BI above? It should work in your scenario.Smiley Happy

 

Regards

Ancar Frequent Visitor
Frequent Visitor

Re: Percent values comes with wrong decimals

Hi JoHo_BI,

Thank you for the reply and the solution - it worked perfect! Exactly what I needed! Thanks a lot for your help!

Kind regards,

Andreas

Ancar Frequent Visitor
Frequent Visitor

Re: Percent values comes with wrong decimals

Hi there,

Yes, it worked perfect! Thanks!

//Andreas

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 168 members 1,913 guests
Please welcome our newest community members: