Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Glitch with Conditional columns

I have a problem with the data type of a conditional colum. I have a whole Number column I am modifying to group values together, but the output is being treated as text and not a whole number. I ca...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    You need to create a measure to change your value,using  fixed(value,number),number here equals the number of decimal places.

    As you see below:

     

    If you choose "0",it will convert into a int like number.But it's text type.

     

    Here is the reference.

     
    Best Regards,
    Kelly
     
    Did I answer your question? Mark my post as a solution!

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Have you tried reducing the no of decimal place to 0, in number formatting?

 

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin