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,
I have created a table that has two columns. The second column is a percent complete column. I would like to make this card but when I do it shows it a 0.99 instead of 99%. I would like to be able to display it as 99%, I am unsure of how to do this. Everything I have looked at is how to display as a percent if it is a calculated measure but mine is not, it is pulled in from an excel file.
Hi @jjasper,
You need to format the column as a %.
You must select the column and on the modeling tab select the data type as %.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI have done that but the percent section is grayed out so I am unable to click on it to make it a percent. I am not sure if it has something to do with how my column is set up.
Thanks
Jes
Hi @jjasper,
Check on the top of the formatting if the type of your data is number? If it's text you first need to change it to number and then apply the %.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIt is a number. I still can't get it to give me the option to change it to a percent. I am not sure what I am doing wrong and why I can't get it to show. It is still grayed out even as a number option. Maybe I just can't do it.
Thanks
Jes
Hi @jjasper
Did you select the column first then choose the percent? If it is not your case, please share your data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |