Forum Discussion

Otso's avatar
Otso
New Member
9 years ago

Power BI Publisher for Excel transforms values into text

I have several calculated columns (decimal-type) in PBI, which work well when I create PBI reports. When I connect to Excel using "Connect to Data" the numbers convert to text, and manipulating/ranki...
Need Help
Otso's avatar
Otso
New Member
9 years ago

MattAllington, I have explicit measures built I use for the Values section, but for Rows section, I (try to) use calculated columns. I have about 400k rows that need to be ranked, but I'm unable to do that as the Pivot table treats the row values as text (99.89, 997, 99.6, etc.).

  • DieterH's avatar
    DieterH
    New Member
    9 years ago

    I have the same problem. Also if I transform explicitly the type via power query to Type.Int64 it will be handled in the data modell like text.

    Is there anysolution

    Thanks