cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data formatting - Numbers are identified as text

Hello everyone!

I'm kinda new to PBI and stumbled across a problem that I have no idea how to solve.

In query editor I have a table with column formats set to match the data types. Column "Сумма" format is explicitly set to number. 

bpn1973_1-1596716458985.png

bpn1973_2-1596716482327.png

When I try to add amounts to the matrix table or to any visual the amount is added either to Columns or Rows but not to data fields. Any ideas? 

 

bpn1973_0-1596724093221.png

bpn1973_1-1596724223091.png

 

Thx in advance for any tips or help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Data formatting - Numbers are identified as text

Created a new file and CopyPasted the full query to the new file.

Everything works fine.

bpn1973_0-1596726470817.png

 

The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.

Could it possibly be one of the reasons for a glitch? 

View solution in original post

9 REPLIES 9
Highlighted
Super User IV
Super User IV

Re: Data formatting - Numbers are identified as text

HI @bpn1973 ,

 

Can you click on your column on the FILEDS pane ansd check what data format it has got on the top ribbon as shown below:

Pragati11_0-1596725235698.png

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Highlighted
Community Champion
Community Champion

Re: Data formatting - Numbers are identified as text

@bpn1973 

Possibly, it could be formatted as TEXT in the data model though you set the type as Number in Power Query. Please check.
If it doesn't work, make sure any subsequent steps in Power Query didn't change the type.

Fowmy_0-1596725197502.png

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

 

Highlighted
Super User IX
Super User IX

Re: Data formatting - Numbers are identified as text

@bpn1973 , I doubt it is still a number. Check in the column tools . Change if needed

Data Format New Rib.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: Data formatting - Numbers are identified as text

bpn1973_1-1596725679365.png

 

 

I use Russian version 

In Data Type and Format - its Whole Number, in Summarization its Sum

Highlighted
Frequent Visitor

Re: Data formatting - Numbers are identified as text

Created a new file and CopyPasted the full query to the new file.

Everything works fine.

bpn1973_0-1596726470817.png

 

The only difference is that I did not create any measures and did not create any calculation tables in Tabular Editor.

Could it possibly be one of the reasons for a glitch? 

View solution in original post

Highlighted
Super User IV
Super User IV

Re: Data formatting - Numbers are identified as text

Hi @bpn1973 ,

 

No creating caluclations or measures won't affect the datatype of the column until it is chnaged explicitly.

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Highlighted
Impactful Individual
Impactful Individual

Re: Data formatting - Numbers are identified as text

@bpn1973 there are three places where you can change the data type (you can't change text to number if text has non-numeric characters)

1. source : Define the data type in the source data if possible

2. power query: change the data type here if you can't change it in the source

3. Power Bi desktop: finally, if it is not possible to change the data type in above two cases then change here. There are few data type which are only supported in the power bi desktop

Highlighted
Super User V
Super User V

Re: Data formatting - Numbers are identified as text

Hi @bpn1973 ,

 

You have cymma as a measure and a Column.

 

Try renaming one to a different name.

 

Regards,

Harsh Nathani

Highlighted
Community Support
Community Support

Re: Data formatting - Numbers are identified as text

Hi , @bpn1973 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. 

For now, there is no content of description in the thread. If you still need help, please share more details to us.

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors