Forum Discussion
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 can not then change the type to whole number, as I get the demand to convert it to Import Mode, which I want to avoid. It did accept decimal number, which looks fine in the query, but as soon as I drag it to the X axis, they all display with .00 at the end, which I don't want. So now I am going to have to build an index table and a relationship to get them in the right order, so the question is why can't I do a direct query and have the contional column output whole numbers??
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,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
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 LinkedinAnonymous , is your issue resolved
Hi Anonymous ,
Does amitchandak 's suggestion work?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
