Power BI

Planned

Percentage format support in table and line chart

Vote (81)

Power BI User on 29 Jul 2015 22:18:44

Could we change double format to percent style in table and other chart? such as 0.12 to 12% ?

Administrator on 29 Jul 2015 22:29:11

Hi - we're going to add more formatting options, but for now if you set the formatting of the field on the Modelling tab, it should be reflected in the report visuals

Comments (5)

Comments (5)

Jihong Zhang on 05 Jul 2020 23:14:26

RE: Percentage format support in table and line chart

For line chart, we would like to be able to label data labels and Y-Axis as percentages. If we can use the values from another column as labels, that would be even better!

Jim Howard-Birt on 05 Jul 2020 22:53:32

RE: Percentage format support in table and line chart

So this was planned in 2015 its now 2017 and still not available? When exactly will this be available?

Robert K. Bell on 05 Jul 2020 22:30:21

RE: Percentage format support in table and line chart

We'd use this a lot! My current "frown" experience with Power BI is not being able to set a display format for a column AND have it sortable based on the unformatted data. I.e., a column contains decimal numbers, but actually represents fractional minutes — so `1.5` should appear as "1m30s", but be sorted on the value of `1.5`.

Sławek Graczyk on 05 Jul 2020 22:25:07

RE: Percentage format support in table and line chart

Hi

i want to use formating in tab Modelling but all this field is inactive on my power bi
do you know why?
thanks for help
Sławek

Alexander on 05 Jul 2020 22:23:14

RE: Percentage format support in table and line chart

I agree, it is not visually pleasant to see floats when the datasheet expressed the data type as a percentage. For example, in a line chart; the Y-axis would yield a .65 instead of 65% .