Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Changing the number format for legend label

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 fro...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
10 years ago

Anonymous Can you please share a screen shot

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
    HarrisMalik
    Icon for Continued Contributor rankContinued Contributor
    10 years ago

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