Forum Discussion

Stilish's avatar
Stilish
Frequent Visitor
6 years ago

Percentage Format from Data Model not reflecting in pivot table

Hi there I have set up a data model from which I have created a pivot table. I have fields where the data type format in the data model is percentage. This format reflects in the field filter drop d...
Data model
pivot table
Power Pivot
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago

Create a new calculated column:

Stilish's avatar
Stilish
Frequent Visitor
6 years ago

Thanks AntrikshSharma 

That does help a lot.

However, how do I retain the 2 decimal point format? i.e. 0.50% and 1.00% instead of 0.5% and 1% as per below:

 

Many thanks

  • AntrikshSharma's avatar
    AntrikshSharma
    Icon for Community Champion rankCommunity Champion
    6 years ago

    0.5, 0.1, 0.75 are decimal numbers so their percentage counterparts would be 50%, 10%, and 75%

    • Stilish's avatar
      Stilish
      Frequent Visitor
      6 years ago

      Hi AntrikshSharma 

      The problem is my decimals are 0.0010, 0.0020, .....0.0100, 0.0125,00.0150 that I want to display as 0.10%, 0.20%, ....1.00%, 1.25%,  1.50%, etc.

      Do you know how I could achieve that?

      Thanks again for all your assistance.