Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have this following table as my input file to powerBI that has both decimals and percentages in a field:
Is there a way to bring this up without converting everything to decimal in powerBI?
Right now, everything converts to decimal without making any transformations. I dont want to change all the values to percentages.
Solved! Go to Solution.
Hi,
try this measure, essentially you need to select the KPI to link the associated format to it:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi @Anonymous ,
As far as I know, Power BI is calculated based on columns, so there will be only one data type/data format in each column.
So when you load the data with percentage type or decimal number type into Power BI, there will be only decimal number type on this column.
You can try FORMAT() function as their suggestions. However, your column will be convert to text type due to this function.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
try this measure, essentially you need to select the KPI to link the associated format to it:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hello @Anonymous create a new column and its calculation looks as below:
If(KPI = "Z', FORMAT('TABLE'[VALUES],"0%"), 'TABLE'[VALUES])
this will create new column and only Z will be converted not all others.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |