Skip to main content

Power BI

Needs Votes

data format as bytes

Vote (91) Share
HUX's profile image

HUX on 17 Sep 2016 06:11:55

I'd like the ability to format a number as bytes (KB, MB, GB, TB, PB, EB)

Comments (6)
HUX's profile image Profile Picture

Nick Dorak on 26 May 2023 18:10:51

RE: data format as bytes

This would be great, especially when units are set to Auto! For example, instead of showing 20.13 Million GB and 5.44k GB, it could display as 20.13 PB and 5.44 TB.

HUX's profile image Profile Picture

Sverre on 06 Jul 2020 00:16:08

RE: data format as bytes

A bytes/kilobytes/megabytes etc data type would be very helpful instead of multiplying columns by 1024 or more. One big challenge currently is that if you try to report on petabytes of data the Y axis in your graph will start showing scientific notation like 3E+15 which is not very user friendly.

HUX's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:56

RE: data format as bytes

Field properties in the Power BI Data Model allow formatting for currencies and scientific numbers, missing is data size formatting like automatic scaling into Bytes, Megabytes, Kilobytes and so on.
Scientific formatting is close to it but 4.513€+11 Bytes is hard to use.

HUX's profile image Profile Picture

Jonathan Hunter on 05 Jul 2020 23:40:18

RE: data format as bytes

It's been 20 months PM team. It's amazing to me that you guys can make such an awesome product so tedious to use. Please bring us usability features, like automatic data format calculations, the type that are commonly used in IT. Based on a field type being "data" assumed in either "Bytes, KB, MB, GB, TB, etc." the reports should automatically update to the best-fit values. If working in GB, the report shouldn't show 1800 GB, it should show 1.8 TB, as an example.

HUX's profile image Profile Picture

Khoi Nguyen on 05 Jul 2020 23:31:10

RE: data format as bytes

I would also like this feature.

HUX's profile image Profile Picture

Jonathan Hunter on 05 Jul 2020 22:51:29

RE: data format as bytes

This is certainly needed. When working with large data sets that are noted in bytes, trying to manage their conversions to GB, TB, PB, etc. is annoying.