Forum Discussion
Solved
Measure in between Brackets
Hello PBI Nation, Need a small help. Im trying to create a measue that show percentage. example : 89% Im able to come up with the calculation and the correct number, but i want the percentag...
The measure calculating the percentage will most likely return the value 0.89.
When selecting this as a percentage Power BI makes sure it looks like 89%. (0.89*100).
So basically you have to create the string like:"(" & (precentage calculation)*100 & "%)"
Thank you so much for th reply.
I have tried this, but the problem with it is that it returns with a lot of numbers after the decimal point.
Example: (89.1231245%)
Any way i can limit the numbers to 1 place after the decimal point. i.e. (89.1%)
please let me know.
Please ignore my previour message. was able to fix it with Fixed() function. thanks for the help this works just fine. 🙂