Year is not showing properly in Table

[Narender]

Hi All,

I am creating a table with 1 dimension (Year) and one new measure .

Measure 2 = CALCULATE (
SUM (TAX[TAX_SUB.AMOUNT]))

After that i am placing both Dimension and Measure in value part under Table property.

But the year is not showing properly. year is showing  some strange value like below:

Year       Measure 2

735475       12767678.78

I want year like 2015,2016,2017 means measure 2 Group by year.

Although Year is showing properly in slicer.

Please let me know how to show year spereatly with amount.

Thanks,

Narender

[Phil_Seamark · Accepted solution]

Can you change the "Year" column to be text?  Or set the default sum of the column to "do not sum"

I suspect that Power BI sees the year field as a number and is just trying to sum all the values in that column.

[Narender]

Thanks Phil.

Do not summerize is working for me.

Narender