Line Chart Data Labels Custom Display Units

Question

Hi,&nbsp;I am using Line chart to display the data values which are in bytes. Currently the display unit is auto and hence it shows values in billions or Millions. I want to change the display Unit to Mega Bytes instead. Is there a way to do so?&nbsp;

philiptreacy · Answer

Hi&nbsp;sakshimit&nbsp;
&nbsp;
Download example PBIX
&nbsp;
Create a measure to convert Bytes to MB
Measure = SELECTEDVALUE('Table'[MB])/1024
&nbsp;
Select the new Measure and Set the Display Format to #,##0 \MB

&nbsp;
Plot the measure

&nbsp;
Regards
&nbsp;
Phil
&nbsp;

sakshimit · Answer

I cannot find the option to&nbsp;Set the Display Format to&nbsp;#,##0 \MB. It is only showing text in the dropdown for Format.

philiptreacy · Answer

Hi&nbsp;sakshimit&nbsp;
&nbsp;
Your measure is using FORMAT to return a value.&nbsp; FORMAT returns a string and you can't apply number formatting&nbsp; like #,##0 \ MB to a string.
&nbsp;
If you have a number you just type into Format area to apply the special formatting.
&nbsp;
Further info here&nbsp;https://www.myonlinetraininghub.com/custom-formatting-strings-in-power-bi
&nbsp;
Your original question said you wanted to format valuies in MB, but your measure is formatting them in KB, MB, GB etc.
&nbsp;
So what is it you actually are trying to do?
&nbsp;
Regards
&nbsp;
Phil

sakshimit · Answer

Hi,The MB requirements are met with the soution you provided. However, I wanted to extend it further to dynamically convert the values to KB, MB &amp; GB. Is it possible to acheive the same?

Forum Discussion

Line Chart Data Labels Custom Display Units

Related content

custom map doesn't display properly

Pie Chart Custom Data Label

Heatmap Formatting - Display Days and Hours (Custom Axis Labels)

Custom data labels display nothing

Displaying labels on an Azure Map visual in Power BI