Forum Discussion
Measure in between Brackets
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 & "%)"
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.
You can use ROUND()
ROUND(<number>, <num_digits>)Please ignore my previour message. was able to fix it with Fixed() function. thanks for the help this works just fine. 🙂
