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.
Hello:
As shown below i have values in percentage, i want to know how i can display as percentage in Power BI where i can see % inside chart.
Any help is greatly appreciated.
Thanking you inadvance.
Thanks
Regards
Jay
VOLUME_IN_PERCENT |
57.91 |
59.87 |
89.97 |
75.15 |
65.5 |
52.3 |
77.79 |
67.47 |
73.1 |
81.34 |
67.35 |
75.95 |
89.84 |
70.17 |
75.21 |
84 |
82.32 |
Solved! Go to Solution.
the easiest way would be to add a calc. column just with
New Percentage = Table1[Volumne_in_Percent] & "%"
But this will give you text and you can't continue to calculate with these values.
the cleaner way is to transform your column in Power Query using Division by 100.
Then all your values become decimal values and you can change the format to Percentage
the easiest way would be to add a calc. column just with
New Percentage = Table1[Volumne_in_Percent] & "%"
But this will give you text and you can't continue to calculate with these values.
the cleaner way is to transform your column in Power Query using Division by 100.
Then all your values become decimal values and you can change the format to Percentage
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 |
---|---|
108 | |
97 | |
79 | |
67 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |