How to show the numbers and percentages values both at a time in a single matrix in powerbi

[Usha_pk]

Hi team,

I'm working on a report in which both the numbers and percentage value should be shown at a time in a matrix. Can you please suggest me on this.
This is how the matix should be displayed.

But I'm getting the below one.

@amitchandak @Greg_Deckler @Ritaf1983 @Anand24 : If you have any idea please do suggest, it would be more helpful. Thanks a lot!!!

[Usha_pk]

@Ritaf1983 Thanks a lot, Helped to solve me issue.

[Ritaf1983]

You're welcome 🙂

[Ritaf1983 · Accepted solution]

Hi @Usha_pk 
Yes , you can use "format " function.

overall = if(SELECTEDVALUE('Table'[Category])="% sales" , FORMAT([sum_]*100,"0.0%"),FORMAT([sum_],"0,00.00"))

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly