Changing the number format for legend label

[Anonymous]

I have an on-premise tabular model with a fact/date table.  The date table has a Year column displaying years as 2014, 2015.

When I create a line chart on Power BI.com and add the Year column from the date table to the Legend it displays as 2,014.0

How can I change the legend formatting with the Power BI service?

[HarrisMalik]

@Anonymous The type of axis is Continious your have change it to Categorial to get Year values. 

Step By Step:

1. Select the chart which is showing Continious values for years

2. In the right pane go to Format tab

3. Open the axis which has Years suppose it is X-axis

Change the property Type from Continious to Categorial

Cheers

Harris

[Anonymous]

This doesn't work.  In any case the Year is on the Legend (series) rather than the X Axis.

[HarrisMalik]

@Anonymous Can you please share a screen shot

[Anonymous · Accepted solution]

Hi

I solved this problem.    A little background.  The field was a calculated field (tabular) for FiscalYear.  In Tabular and SSMS the appearance of the number was fine.    In Power BI Desktop & Service the number changed to 2,015.00.  The reason is because in Tabular the property of the columns for Data Format was Auto.  I suppose Power BI is trying to be helpful.  When I set the format to Whole Number and redeployed the problem went way. 

Thanks for your help.

[HarrisMalik]

@Anonymous Good that you found the solution. Please mark the post as answered so others can benfit from it.