cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Helper I
Helper I

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 II
Super User II

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!




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 IV
Super User IV

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
Helper I
Helper I

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
Helper I
Helper I

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 II
Super User II

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
Solution Sage
Solution Sage

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 III
Super User III

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
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors