Apparently Decimal columns do not act as numbers on visuals

[lomyk]

Looking for help!

I have a decimal column, and when to use it (as a number) on a visual, it pretends to be a non numeric column 🙂 , and of course I cannot even drop in a value well. 

Any idea?

Please and thank you! 

[v-yajiewan-msft]

Hi @lomyk ,

Is there any progress on this issue? Does Wilson's answer resolve your confusion?

If you find any answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

[Wilson_]

Hi lomyk,

Can you please better explain what you are expecting to see? I'm not following on what the issue is.

[lomyk]

Thank you for trying to help me. 

I expect to be able to use Contracted Area column in a visual, for ex: a card visual. For me, looks like is correctly formated, as a decimal number (see above screenshot), but in the Data pane you can see that this Contracted Area column does not have the sum symbol in front, what makes me feel that this column is not seen/treated as a decimal/number data type. When I try to use it in a card visual, doesn't let me bring the column to the Value well of the card visual. 

As a test, I exported that single table as  csv file, then I used it as a datasource for a test pbix. Now I have no issue creating a card visual or any other visuals with this Contracted Area column, and yes -  it has the sum symbol in front :).

Below screenshot is from my test pbix

Question is: why in my real (above) example, when I foramted the Contracted Area column, exactly the same as in below test, I cannot drag the Contracted Area in a Card visual, and the column name does not have the sum Symbol in front. 

Thank you so much 

I have to 

[Wilson_ · Accepted solution]

lomyk,

Ah I see, your issue is you can't use the field in an implicit measure. It is still a number; it just won't aggregate automatically when you try.

Check and see if implicit measures are discouraged in your pbix.

P.S.: Implicit measures are not a best practice anyway. You are better off creating a measure that is equal to SUM ( 'Dim_<CustomFields>'[Contracted Area] ). 🙂

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

[lomyk]

Thank you Wilson! Worked!