Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I currently encountered a strange situation: when I created a new conditional column (in the example I called it "Order_Category") from Home -> Edit Queries after inputting a CSV file, the Order_Category column ONLY appeared in the filed with other columns but does NOT exist in the drop down list when I went to Modeling -> Sort by Column.
Below are some screen shots for your reference.
Since the dummy CSV file does not have the same issue but the really CSV file I generated from SPSS (file size is around 14 MB.) does, I am wondering that which step went wrong.
I do not think file size matters, but when I create CSV dummy files, they do not have the same issue.
Thank you in advance!
Solved! Go to Solution.
Hi,
Try to change the number format in calculated column to Whole Number.
Thanks
Hi,
Try to change the number format in calculated column to Whole Number.
Thanks
Hi @Anonymous
It should be working. Can you post the pbix file on Google Drive / One Drive and share the link here to probe further.
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |