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 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's avatar
    Anonymous
    Not applicable
    10 years ago

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

    • 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.