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

Fields panel showing columns with numbers as text

Hi All,

 

I have a strange problem here. Columns that store numbers are being shown as text but only in the "Fields" panel. 

I've checked data types in Power query and in Data view and both are showing the correct data type. 

 

What's going on?

 

Below you can see a view from the Fields panel.

"MTD Actual" and "MTD Budget" should both be seen as "Decimal numbers".

Danielnir_0-1628159534098.png

 

Views from where data types were set:

1. Power Query:

Danielnir_1-1628159642438.png

2. Data view:

Danielnir_2-1628159689357.png

Danielnir_3-1628159709545.png

 

I even deleted all measures that could be converting data types to other. No change.

 

6 REPLIES 6
Danielnir
Frequent Visitor

Hi,

 

Yes, both are set to summarise.

Danielnir_0-1628162646311.png

 

Hi @Danielnir ,

 

Did you set this summarisation now? Does this show summation sign against your column under Fields pane in Power BI?

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






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


Proud to be a Super User!




Unfortunately not. I still need help with it. 

Hi @Danielnir ,

 

Can you tell me what version of Power BI are you working with? I don't see this at my end.

Also are you using Calculation Groups by any chance through Tabular Editor?

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






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


Proud to be a Super User!




My Power BI version is 2.95.983.0 64-bit (July 2021) and I don't have any calculation group in Tabular Editor. I'm loosing my mind over this one 😄 

I'm deleting tabular editor and Dax studio as those are the only things that I installed prior to having that strange situation.

Pragati11
Super User
Super User

Hi @Danielnir ,

 

The first thing what I see in your screenshot for column data-types -

What is the summarisation set on these fields? If it is set to Don't Summarise  then it is showing right in the FIELDS pane.

When you set something on these columns as a summariation like SUM/AVERAGE/MIN/MAX, then under FIELDS pane you see a "summation icon" against the numeric columns.

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






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


Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!