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

Alternatively if you didn't want to set your data field to be treated as a percentage globally, then on you chart you can right click on the Value, and at the bottom of the context menu there is Show value as...

 

On here there should be some percentage options.

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?