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

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.

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

        Always happy to help someone save their hair! As I age, hopefully this will translate into positive hair karma for me!