MarkCBB
Active Member
- Joined
- Apr 12, 2010
- Messages
- 497
Hi there,
I am using PQ in the PBI Desktop, I am getting data from Excel, however one of the values columns that contain numbers are formatting as text, i.e. right aligned, once I have imported the data into the PQ and updated the column data type to Whole numbers the Charts do not populate with the values, There is no DAX. If I open the Excel file and correct the text number to numbers and reload into Power BI, the chart works. Why is this? is there any to get PQ to do the heavy lifting, or do I need to ensure that the data going into PQ is corrected before importing?
I know is sounds silly, but I get these files every 2-3 hours, and I really dont want to have to manually (or VBA) to fix the problem, I am sure that PQ should be able to do this.
It is important to note that not all the values in the column are text numbers, just some of them.
The formulas I use to update them in Excel is Value -0, then paste special over the column
I am using PQ in the PBI Desktop, I am getting data from Excel, however one of the values columns that contain numbers are formatting as text, i.e. right aligned, once I have imported the data into the PQ and updated the column data type to Whole numbers the Charts do not populate with the values, There is no DAX. If I open the Excel file and correct the text number to numbers and reload into Power BI, the chart works. Why is this? is there any to get PQ to do the heavy lifting, or do I need to ensure that the data going into PQ is corrected before importing?
I know is sounds silly, but I get these files every 2-3 hours, and I really dont want to have to manually (or VBA) to fix the problem, I am sure that PQ should be able to do this.
It is important to note that not all the values in the column are text numbers, just some of them.
The formulas I use to update them in Excel is Value -0, then paste special over the column
