post query

[tejal]

Hi

I need to show values as percentage in the Bar chart

It is showing as 1.0 instead of 100%, 0.5 instead of 50%, original data query which is a Excel file contains values in percentage

Also I have changed the Data type to percentage in the edit query window

Still it reflects as numbers

Pls help

[Omega]

Did you try changing from the formatting pane? If still not working, please share sample data. 

[tejal]

The formatting area under the Modelling tab is greyed out for me

Pls note am using the trial version

[Omega · Accepted solution]

In the fields pane (Right most), where all the tables and fields are available, click on the measure/column you want to change to percentage. Then, change in the formatting ribbon