Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Im trying to make this column percentage values so they dont come out as 3000.00% rather than 30%. Attatched is my formula for the calculated column and an example of how they are coming out.
Solved! Go to Solution.
@dkehoe32 What is the value you are returning? 30 or .30? You need the output of the value to be in the decimal in order for the percentage to appear appropriately as it will always move the decimal two places to the right of your value. So, either do that on the base column value, or add "/ 100" to your lookup value to modify your output.
@dkehoe32 What is the value you are returning? 30 or .30? You need the output of the value to be in the decimal in order for the percentage to appear appropriately as it will always move the decimal two places to the right of your value. So, either do that on the base column value, or add "/ 100" to your lookup value to modify your output.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |