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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.