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.

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

Thanks, though for some reason I can't find this option.

 

Am I clicking on the right item? (cf. pictures below)

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

What version of Desktop are you running? I've got Version: 2.55.5010.641 64-bit (February 2018)

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

    Odd, I'm using the exact same one 

    • 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 :)