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 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?

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.

     

5 Replies

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