Skip to main content

Power BI

New

Change multiple measures number formatting at one time from Modeling

Vote (61) Share
Alex G's profile image

Alex G on 13 Jun 2017 01:15:49

I have many measures that I need to be in Currency format, with zero decimals. This can't be done in the Query Editor, and must be done one by one from the Modeling tab on the Ribbon. I would love the ability to either Ctrl+Click on multiple measure to select many and then apply the new format. Or, possibly a keyboard shortcut similar to F4 in Excel to repeat the previous action.

Comments (4)
Alex G's profile image Profile Picture

b11b7dcf 51c7-ea11-a812-000d3a579c34 on 16 Jul 2020 10:50:58

RE: Change multiple measures number formatting at one time from Modeling

Would be great to be able to do it from Top Ribbon in Report as well. Selecting multiple measures with Ctrl + click and then applying specific format to all at once - would save a lot of time. Basic feature, I am really surprised it is not possible.

Alex G's profile image Profile Picture

51a2be8a 9a65-443c-bd0f-6b192d1e9256 on 06 Jul 2020 00:03:13

RE: Change multiple measures number formatting at one time from Modeling

and allow multiple format changes in one click, instead of for example, 'whole number' then 'comma separator'.

Alex G's profile image Profile Picture

35a3346b 3361-4c53-901f-0ff7a485e013 on 05 Jul 2020 23:52:49

RE: Change multiple measures number formatting at one time from Modeling

It is shocking that such a simple thing is absent in an otherwise incredibly intelligent and user-friendly program. Would love to see this.

Alex G's profile image Profile Picture

3101328d e4e2-4d82-a3ff-9aefdd878e1e on 05 Jul 2020 23:12:54

RE: Change multiple measures number formatting at one time from Modeling

Yeah, I've spent hours on formatting measures, when I feel like I should be able to do it in just a few minutes.