Forum Discussion
Solved
Text should be text and numeric values should be converted to percentage
Hi everyone, One Column (Data type text) contains text and numeric values. Text should be text and numeric values should be converted to percentage in Power BI. how i will get this. This sa...
Hi Gopiraju404 please check this custom column
=if Value.Is(Value.FromText([Q1]), type number)
then Text.From(Number.Round(Value.FromText([Q1]) * 100, 2)) & "%"
else [Q1]Hey Gopiraju404 ,
next to using Power Query you can also use Dynamic formatting if you create a measure: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
Hopefully, this adds some new ideas.
Regards,
Tom
v-sdhruv
Community Support
Community SupportHi @Gopiraju404 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You