The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 & "%)"
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. 🙂
You can use ROUND()
ROUND(<number>, <num_digits>)
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |