Skip to main content

Power BI

Needs Votes

Default measure format to comma and zero decimals

Vote (425) 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 (18)
Wyn Hopkins's profile image Profile Picture

Chuck Roberts on 17 Nov 2022 11:06:36

RE: Default measure format to comma and zero decimals

I agree. We need an option to set the default format for numbers with a comma (or the default thousands separator set at the OS level), and 0 decimal points. for all old and new PBIX files.

Wyn Hopkins's profile image Profile Picture

Celia Alves 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

Nikolay 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

Power BI Ideas Admin 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

AJ 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

Paul Turley 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

Eric Hutton 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

Power BI Ideas Admin 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

Power BI Ideas Admin 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

Power BI User 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.