<div>
Can you share an example?&nbsp;&nbsp;
</div>


<div>
the text value in the field is 0.05 which equates to 0.05% ... when i convert that to a percentage in the query editor the conversion makes it 5% instead of 0.05%
</div>


the text value in the field is 0.05 which equates to 0.05% ... when i convert that to a percentage in the query editor the conversion makes it 5% instead of 0.05%

<div>
I still don't have a solution for this.... any thoughts?
</div>


I still don't have a solution for this.... any thoughts?

Solutions Architect

Ken H.

<div>
<div class="content wysiwyg-content fr-view">
<p>I have a percentage value that starts as text (0.05 as an example). If I convert it to a percentage it gets calculated as 5% instead of 0.05% ... and if i convert it to a decimal it keeps the format but i can't get it to report as a percentage in reports. Does anyone have an idea of how I can convert this text to the proper percentage value of 0.05%?</p>
</div>
</div>



I have a percentage value that starts as text (0.05 as an example). If I convert it to a percentage it gets calculated as 5% instead of 0.05% ... and if i convert it to a decimal it keeps the format but i can't get it to report as a percentage in reports. Does anyone have an idea of how I can convert this text to the proper percentage value of 0.05%?

Power BI text to percentage conversion.

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.