Measure value format

[Arnault_]

Hi community,

I am having some difficulties to figure out how to get values in the proper format.

In my report I can choose different measures (swith fx) and these measures interact with the charts (see below).

Now, there is something I do not understand. I have two similar charts (I have copied the first one to build the second one and I just changed the item on the axis. The below picture shows the 2 charts displaying the same measure but in a different format. In the second chart the values is displayed in "billions" which is of course not appropriate.

How can this be explained and fixed?

Same chart with identical settings, same measure ... and different result ...

PS : For the 2 charts, the label data format is "auto" and this is the only option since depending on the measure selected, I can have Thousands or Millions.

Thanks in advance for your help.

[v-juanli-msft]

Hi @Arnault_

i need to know your data, measures and how your create the visuals.

Could you share a simple example pbix for me to play with?

Best Regards

Maggie

[Arnault_]

Hi @v-juanli-msft,

Thanks for your reply.

Here is the link to download the PBIX. I have removed charts and pages, however I have kept the original dataset to make sure you have enough data to play with.

The charts are based on the following measure :

Selected Metric = 
SWITCH( TRUE();
	'DIM Metric Selection'[Metric Selected] = "Sales"; [Total Sales];
	'DIM Metric Selection'[Metric Selected] = "Order lines";[Total order lines];
	'DIM Metric Selection'[Metric Selected] = "Packing lines"; [Total packing lines];
    'DIM Metric Selection'[Metric Selected] = "Volume"; [Total volume];
    'DIM Metric Selection'[Metric Selected] = "Weight"; [Total weight];
[Total Sales] )

The different measures can be found in the following table : FX Key Measures

Thanks in advance for your support.

Cheers

Pbix file

[v-juanli-msft]

Hi @Arnault_

Please make sure you have removed privacy information.

Best Regards

Maggie

[Arnault_]

Hi @v-juanli-msft,

No problem, the data are based on simulation, so nothing real. Thanks for your advice.

Cheers

[v-juanli-msft]

Hi @Arnault_

I create a new table with the same data, when i add columns in the column chart, it displays "K" by default for data both from your first chart and the second chart.

it is not clear how it works behind the "data label".

To get what result you want, you can change the "Display units" under "Data labels" or "Y-axis".

Best Regards

Maggie

[Arnault_ · Accepted solution]

Hi @v-juanli-msft and many thanks for your help.

I just found something interesting. The display units change due to the size of the chart. Here is a picture below with the exact same charts. I just copied and pasted the first one and resized the second one and you can see that the units have changed automatically.

Again many thanks for your support.

Cheers