Forum Discussion
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...
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.).
Hi Otso,
What is your data source? Would you mind sharing me sample data of your scenario?
I make a test using my sample data, but I am not able to reproduce your issue. When I connect to my dataset that has calculated column(decimal-type) from Excel, I can successfully drag the calculated column to ROWS section. You can check the following screenshots to get more details.
Thanks,
Lydia Zhang