cancel
Showing results for
Did you mean:
Highlighted
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
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.

4 REPLIES 4
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.

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.

Regards

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

Frequent Visitor

Re: Percent values comes with wrong decimals

Hi there,

Yes, it worked perfect! Thanks!

//Andreas

Announcements

Challenge: Can You Solve These?

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

Community News & Announcements

Get your latest community news and announcements.

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.

Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 168 members 1,913 guests
Recent signins: