Skip to main content

Power BI

New

data format as bytes

Vote (81) 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 (5)
HUX's profile image Profile Picture

7bb9c5b2 068f-47e8-88bc-feab874fa85c 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

1da80326 68d3-4492-bfb4-770be548cd2a 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

2455c654 5278-43cd-b545-fa7ec18e0369 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

87dc7ff9 6775-4bfa-806d-99a491eb70ff on 05 Jul 2020 23:31:10

RE: data format as bytes

I would also like this feature.

HUX's profile image Profile Picture

313a6810 3bd4-41c5-9730-3a724dfc8067 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.