Forum Discussion

Arcturus's avatar
Arcturus
Icon for Helper I rankHelper I
8 years ago
Solved

Percentages displaying as decimals

Hi all,   Percentages, taken from a column turned into Percentage Type, currently display as decimals in the report view (i.e., 0,87 instead of 87%).   How do I correct it in a "cleaner" way than...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    In the data model, click on the column and then go to the Modeling tab and click the "%" format button.

Chris99's avatar
Chris99
Icon for Advocate III rankAdvocate III
8 years ago

Hmm. You're right clicking on your Average of Unemployment Rate? Is this a data column or a DAX measure (don't know if it matters)

 

I've changed my visual to a funnel and the option is still there. What if you create a new report visual?

Arcturus's avatar
Arcturus
Icon for Helper I rankHelper I
8 years ago

Spot on!

 

Didn't work because it was a measure and not a value.

 

Got it now, though this will only work if the total of your percentages is equal to 1. Otherwise, you get 100% everywhere :)

 

Thank you so much Chris99 for your kind, sharp and top helpful assistance on all my posts :)

  • Chris99's avatar
    Chris99
    Icon for Advocate III rankAdvocate III
    8 years ago

    Arcturus

     

    Glad to help. I'll be needing the forums plenty in the months to come, so hopefully I'm building up some karma points :smileyhappy: