Home Forums Power Pivot ROWS and COLUMNS in Pivot Tabled based on Tabular Data Model always TEXT?

This topic contains 0 replies, has 1 voice, and was last updated by  debbie.cruz 7 years, 8 months ago.

Viewing 1 post (of 1 total)
  • Author
  • #3030

    • Started: 5
    • Replies: 5
    • Total: 10

    Hoping there is a quick solution for this one. I have migrated my PP Data Model to Tabular. And I’m working to recreate all the Pivot Tables in my report based on the new Tabular data model.

    In my pivot table I have pulled in FISCAL YEAR and FISCAL MONTH from my data model, as the COLUMNS in the pivot table.  Although these fields in the Data Model are set up as Numeric (Whole Number), any field I use in the ROWS and COLUMNS of a Pivot Table will not allow me to change the format, or sort it numerically.  It is treating everything as TEXT. So I can’t change the sort to properly sort numerically in the case of Fiscal  Month.

    Same thing if I have a $ value in Rows/Columns, it doesn’t allow sort numerically, I cannot change decimal places, or add/remove commas (thousand’s separators),

    Any helps is appreciated.


    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

The forum ‘Power Pivot’ is closed to new topics and replies.