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 down but displays as decimal in the pivot table column label.

See images from pivot table and then in the data model:

 

How do I fix this?

Thanks

Data model
pivot table
Power Pivot

4 Replies

    • 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%