Skip to main content

Power BI

Needs Votes

Default measure format to comma and zero decimals

Vote (389) Share
Wyn Hopkins's profile image

Wyn Hopkins on 13 Oct 2018 05:25:31

Every time I create a measure I have to format it as “,” and 0 decimals. This appears to be the most common format and it would make sense to make this the default.

Comments (17)
Wyn Hopkins's profile image Profile Picture

15983bae bad8-ea11-a813-000d3a563be2 on 07 Aug 2020 14:35:04

RE: Default measure format to comma and zero decimals

I see a button "post a comment" (lead to here) and another one that says "needs votes" and does nothing. Where do I vote?

Wyn Hopkins's profile image Profile Picture

5c879015 f2b0-41a0-a3ee-207c5c69e0e6 on 06 Jul 2020 00:10:02

RE: Default measure format to comma and zero decimals

Maybe we need a shortcut!

Wyn Hopkins's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:00:36

RE: Default measure format to comma and zero decimals

It would be better to be able to set your own default format, rather than be stuck with anyone else's idea of the most common format.

Wyn Hopkins's profile image Profile Picture

c9bd0fe3 a170-4944-a40e-bb0fb7d06a9d on 05 Jul 2020 23:58:21

RE: Default measure format to comma and zero decimals

It would be better to be able to set your own default format, rather than be stuck with anyone else's idea of the most common format.

Wyn Hopkins's profile image Profile Picture

7c4c8544 0f6e-4f5b-8dec-025f8be04038 on 05 Jul 2020 23:53:30

RE: Default measure format to comma and zero decimals

Formatting depends on the data type.
The default for Decimal type should be culture-specific thousand separator with two decimals
The default for Whole Number should be culture-specific thousand separator with no decimals

Wyn Hopkins's profile image Profile Picture

d2985fe9 1dd2-4f30-91ae-4cf5dc3e2af6 on 05 Jul 2020 23:49:54

RE: Default measure format to comma and zero decimals

It would be better to be able to set your own default format, rather than be stuck with anyone else's idea of the most common format.

Wyn Hopkins's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:49:50

RE: Default measure format to comma and zero decimals

We do it in Azure Analysis services, so the model has it.

Wyn Hopkins's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:49:49

RE: Default measure format to comma and zero decimals

I get after my developers when they don't put this in, but I have to agree it should be the default...!!!! It was a good chuckle on a Friday that a lot of others hate this too! Please fix!

Wyn Hopkins's profile image Profile Picture

6f0e629f b5f0-4ac4-8a12-c6ddbba33d05 on 05 Jul 2020 23:49:31

RE: Default measure format to comma and zero decimals

I agree with the comment to allow setting the default format via an option.

Wyn Hopkins's profile image Profile Picture

6f0e629f b5f0-4ac4-8a12-c6ddbba33d05 on 05 Jul 2020 23:48:36

RE: Default measure format to comma and zero decimals

Why can't we set the format as an option for the pbix, instead of having one default value "locked-in"? This application has probably fewer user-selectable options than almost any other MS product!!