Year in number format

[akpofureenughwu]

Good day everyone.

I have a set of data like this

Staff	Programme Name	Location	Year	Cost
Jhon Lee	IICT	Foreign	2012	45,000
Paul Beck	ITIL	Local	2011	45,500
Jhon Lee	RedHat	Local	2011	34,000

I have designed a line chart using

Staff, Year as the  drill down dimension and //num(count({<Location = {'Local'}>} DISTINCT [Programme Name]), '#,##0') and num(count({<Location = {'Foreign'}>} DISTINCT [Programme Name]), '#,##0') as measures

When I drill down from staff to year.. the year is expressed as 2.011k, 2.012k. I don't know why?

Please see attached file for visuals 

[micheledenardi · Accepted solution]

Hi,

from the line chart properties, under aspect-> X Axis, uncheck "use continuous scale" .

[akpofureenughwu]

Michele grazie

[tomasz_tru]

Set X-Axis to 'continious'.