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.
Hi,
I have a report see below, where in one of the columns "D" I am unable to change Data Type to Whole Number, alonng with Format to Whole Number and Summarization to Sum.
The one difference I noticed is the numbers are displayed on the left hand side of the column unl;ike the rest whicj are to the right.
Any ideas?
Solved! Go to Solution.
Hi @trevorG1
It's still formated as Text or as Any.
Go back to Query Editor and convert to Number there and load back in
Thanks
Joe
If this post helps, then please consider Accept it as the solution
ct that worked, thanks Joe
Hello @trevorG1 ,
yes as @JoeBarry mentioned, and also check if all the records in the column are numbers.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hi @trevorG1
It's still formated as Text or as Any.
Go back to Query Editor and convert to Number there and load back in
Thanks
Joe
If this post helps, then please consider Accept it as the solution
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |