Forum Discussion
Measure value format
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
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
Hi v-juanli-msft,
No problem, the data are based on simulation, so nothing real. Thanks for your advice.
Cheers
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
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