Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Trying to combine a Decimal number with string

Hi, I'm trying to combine the description in the satisfaction column with the results in the PCT,
I used this code to get the PCT that you see here in the screen , and then used the format options in the menu to show it as a %

PCTOfGrandTotal =

    DIVIDE(

        [SatisfactionCount],

        CALCULATE(SUM('_DFE - Satisfaction (2)'[SatisfactionCount]), ALL('_DFE - Satisfaction (2)'))

    )

MRUry7_2-1706547180417.png

 

For example my goal would be something like
Very Satisfied - 80.86%

But when I use the FORMAT function, like this command

Column = FORMAT('TableName'[PCT],"#")
I see nothing in the column.

How do i convert this PCT to a text field?


Any help is appreciated.

1 ACCEPTED SOLUTION
gadielsolis
Resolver III
Resolver III

Hello,

Please try the following measure

 

Satisfaction %=

    Selectedvalue([Satisfaction])&" - "&Round(PCTOfGrandTotal*100,2)&"%"

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks, For a measure that works perfectly!

But my needs are to use that text as part of a chart, and unfortunately I can't add measures to a chart.
Is there anyway around that?  I'm using the final result you provided as a replacent for just the descriptions.
Something like this but with the formatted descriptions including the %

 

MRUry7_0-1706548778088.png

 




gadielsolis
Resolver III
Resolver III

Hello,

Please try the following measure

 

Satisfaction %=

    Selectedvalue([Satisfaction])&" - "&Round(PCTOfGrandTotal*100,2)&"%"

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors