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.
Hi,
I want to show a measure that I created as %. But the datatype is locked as decimal and I can't change it to whole number. Any ideas?
This is the number I want, but with a % behind:
But when I select % in the modeling ribbon, I get this:
I think changing it to whoule number would fix it, but is locked. The columns I calculate is both whole number.
The calculation I'm doing is this:
That should be 26/154*100 which is 17 if you use round()
Solved! Go to Solution.
If you want to mark as percent column. Then no need to multiply by 100. Multiply with 1.0 to make it decimal
If you want to mark as percent column. Then no need to multiply by 100. Multiply with 1.0 to make it decimal
@amitchandak ah, haha maybe I should have thought about that.
Thanks for pointing that out.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |