cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
swaroopkumarmg Frequent Visitor
Frequent Visitor

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 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.

1 ACCEPTED SOLUTION

Accepted Solutions
EricHulshof Member
Member

Re: 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 & "%)"

View solution in original post

5 REPLIES 5
EricHulshof Member
Member

Re: 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 & "%)"

View solution in original post

Super User IV
Super User IV

Re: Measure in between Brackets

Try

Measure = "(" & [precentage calculation] & ")"
or
Measure = "(" & [precentage calculation]*100 & ")"




Did I answer your question? Mark my post as a solution!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


swaroopkumarmg Frequent Visitor
Frequent Visitor

Re: Measure in between Brackets

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.

 

EricHulshof Member
Member

Re: Measure in between Brackets

You can use ROUND()

ROUND(<number>, <num_digits>)

 

swaroopkumarmg Frequent Visitor
Frequent Visitor

Re: Measure in between Brackets

Please ignore my previour message. was able to fix it with Fixed() function. thanks for the help this works just fine. 🙂

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors