Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
This has never happened to me before, I am working with an excel file that comes with column User Percent value as such 99.23, 99.41, 97.10 or 78.90. I was trying to place the percent sign next to it but when I do that the value changes from 99.23 to 9923.10, 9941.34, 9710.22 what can I do to see the value as 99.23% & 99.41%.
Thank you!
Solved! Go to Solution.
Hi @sraj
In a new column called (%value) divide the column which contains the values you want to display by 100. Add then this new column in your visual and enable % in the menu
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
Hi @sraj
In a new column called (%value) divide the column which contains the values you want to display by 100. Add then this new column in your visual and enable % in the menu
Did it work ? 👌Mark it as a solution to help spreading knowledge 👉A kudos would be appreciated
That worked, thank you!!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |