Forum Discussion

mattpwyman's avatar
mattpwyman
New Member
8 years ago
Solved

Percentages displaying as decimals.

Hi I was wondering if someone can help me I think I'm going mad.

 

I have a Line and clustered column chart where the data on the line refuses to display as a percentage.  The original data in excel is formatted as a percentage:

 

 

 

 

 

 

 

 

When I imported the data I changed the data type to Percentage:

 

 

 

 

 

 

 

 

 

However when drag the data into the line values its displays as decimal:

 

and when I click show data the data is shown as a decimal:

 

 

 

 

 

 

 

I can't understand why it is doing this!!!

 

Thanks

 

Matt.

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Go to the Modeling tab of the ribbon. Click on the column/measure. Click the little % button in the formatting area.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Go to the Modeling tab of the ribbon. Click on the column/measure. Click the little % button in the formatting area.

    • mattpwyman's avatar
      mattpwyman
      New Member
      8 years ago

      Hi Greg,  Thanks for the reply.  I've tried that but when I click on the line the formatting section is greyed out and I can't make any changes:

       

       

       

       

       

       

       

       

      Thanks

       

      Matt.

      • mattpwyman's avatar
        mattpwyman
        New Member
        8 years ago

        AH HA!!! I clicked on the column field with the table and then it let me click on the % sign and the data changed!!

         

        Thanks very much Greg you've saved what hair I have left.

         

        Matt.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi. I've tried to do the same thing. But the "formating" tab is in grey no matter what I do. How can I get the formatting tab to work? Or any other ideas? Thank you!!!