Show percentages instead of values

[remychag]

Hi,

I am looking for one simple thing: I have a chart showing percentages from an Excel file:

But it show the values as values and not percentages (ex: 0,23 and not 23%). Do you know how to change the format to percentages? (Not "Percent of grand total": it doesn't calculate the good data if I use it).

Thanks for your help!!!!

Rémy

[Omega · Accepted solution]

Choose your measure -> on the ribbon, choose Modeling -> Then click on the % button. 

[remychag]

It works, thanks a lot!

RC

[remychag]

Hi,

It unfortunately remains locked when I try..:

(Chart is selected)

[Anonymous · Accepted solution]

@remychag , Select the data displayed in your chart in the Field pane (cf image below)

 

You should then be able to edit its format ! 

If not just tell me we'll try to find another solution 

Etienne

[Omega · Accepted solution]

Choose your measure -> on the ribbon, choose Modeling -> Then click on the % button. 

[Anonymous]

Hi @remychag ,

Have you tried changing data type to decimal number, and then format to percentage ? 

Regards, 

Etienne