Forum Discussion
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 sample data.
Thanks and regards
Gopi
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
5 Replies
- techies
Super User
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] - TomMartens
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-sdhruvCommunity Support
Hi 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- v-sdhruv
Hi @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 - v-sdhruv
Hi @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