Values on Data Points in Thousands

[#1]

Hi

Is it possible to display the Values on Data Points formatted in thousands??

I have formatted the Axis to show in thousands however cant get the Data Points.  I have tried the Excel number format of

#,##0,

but that did not work.

[#2]

The quickest way is to devide your figures by 1000 like this

Sum({$<FiscalYear={$(=Max(total FiscalYear))}>}sales)/1000

Then use the number formatting in the number tab..

I hope this helps...

[#3]

Hi Razavial

Cheers for reply.  I knew that was an option and yes that works for the visual representation but it then means any numbers extract to excel are incorrect and subject to misinterpretation.

I am looking to show the format whilst preserving the full detail.

Mark

[#4]

Ok I get you... I had this same issue... but worked around it by offering both data and a chart in the end..

Sorry.

[rrsrini2907 · Accepted solution]

Hi,

To have exactly the same type as requested, you can follow the below procedure.

Create a combo chart, have two expressions.

One with same metric and another with divided by 1000's and check value on data points for the second metric.

The display option for second metric should be none.

Regards,

Srini.

[#6]

Hi

Cheers, did the above and then converted it to a stacked bar chart and it does exactly what I was after

Thanks !!

[joefeyas]

My axis changes from $B & $M & $K as filters are applied, so this solution will not work.   Any suggestions?

ps.:  Works on the stacked bar chart, I am using un-stacked bar chart and data points do not change with the axis.