Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!