Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 percentage to be displayed on a card in between brackets. Example: (89%)
this is what i'm trying: Measue = "(" & (precentage calculation) & ")"
the minute i do this it turns it into a string and i'm not getting the desired result.
Can anyone please help.
Solved! Go to Solution.
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 & "%)"
Quality over Quantity
Try
Measure = "(" & [precentage calculation] & ")"
or
Measure = "(" & [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 & "%)"
Quality over Quantity
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. 🙂
You can use ROUND()
ROUND(<number>, <num_digits>)
Quality over Quantity
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |