Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Hi @Ancar,
Have you tried the solution provided by JoHo_BI above? It should work in your scenario.
Regards
Hi there,
Yes, it worked perfect! Thanks!
//Andreas
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |