Type percentage And title

[netanel]

Hello everyone!

two questions,

1. Why do I change the Type to Percent I get one result in Query and a different result in visual?

2. Is it possible to call the title the same name as in my example? Change, I did not succeed and so for the second title I called Change_.

A1                A2            A2                                    A1

[artemus · Accepted solution]

1. You need to set the format your value once it is loaded into the model. You can do that by first selecting the value in the field selector, then by going to the modeling tab if your using the older ribbon, or the column tools if using the new ribbon and clicking the % button

2. You can double click the field in the Visualization pane to change its name for that visual

[v-juanli-msft]

Hi @netanel 

It is impossible to make the column keep percent format in column but show another format in the visual, expect you create another measure.

I create measures which names look like the original ones,

but since it doesn't support two same names for column or measure, i add a "." at the end of each name.

%change. = SUM('Table'[%change])

%change._ = SUM('Table'[%change_])

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[netanel]

It doesn't work for me, it brings exactly the same configuration ...

[v-juanli-msft · Accepted solution]

Hi @netanel 

Sorry, i maybe misunderstood you before.

when add columns in visual, please go to "Modeling", chnage the format to "percent", then you column can display percent format.

2. Is it possible to call the title the same name as in my example? Change, I did not succeed and so for the second title I called Change_.

I'm not clear about this reuqirement, could you show me more details?

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[artemus · Accepted solution]

1. You need to set the format your value once it is loaded into the model. You can do that by first selecting the value in the field selector, then by going to the modeling tab if your using the older ribbon, or the column tools if using the new ribbon and clicking the % button

2. You can double click the field in the Visualization pane to change its name for that visual

[netanel]

Thank you very much!