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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Can you only set the data format at the TABLE or DATA SOURCE level?  What if I want to have the data displayed as a decimal in one chart and a percent in another chart?  Is there a way to set the data format at the CHART level in Power BI?