Format number

[jeoosma]

Hi. How can I modify the format in the grapf? Atoumatically it is in currency but in the query the number is decimal and in the graph is as average. I see in the format tile but I don't resolve the problem. Thank you for help.

[v-yuezhe-msft · Accepted solution]

@jeoosma,

Do mask sensitive data before uploading screenshots.

In your screnario, click on your field in the FIELDS panel, then under Modeling ribbon, you can change the format of the field from Currency to Decimal Number. There is an example for your reference.

Regards,
Lydia

[Greg_Deckler]

The second screen shot is from the Query Editor. In the data model, the data type/format may be different because after they come into the model, you can change it. So, you do not want it in currency and you want something other than the average? Not sure what is incorrect.