Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
Microsoft Employeehey ToddChitt . With "default choice" I meant our product makes measures decimal numbers by default and there is nothing you can do to influence that default choice. You can, of course, change the format, but by default every measure starts off like a decimal number and so does a visual calculation. I am sorry if my words caused confusion.
However, you do raise a valid point here about what should be default choice for visual calculations and making that more dependent on the usage. I will make a note and discuss this with the team.
Super User>> With "default choice" I meant our product makes measures decimal numbers by default and there is nothing you can do to influence that default choice.<<
I know it's your product, but please check the default behavior. I have an INT column that is formatted as "Whole number" with 0 decimals. I create a measure from that column and that defaults to Whole number with 0 decimals. I l like it! But then I create a Visual Calculation from the measure or the base column and get 2 decimals.
The product is not doing what you think it is doing in regard to default formatting of Measures. Even if the column is Currency with 2 decimals, the Measure comes out as Currency with Auto decimals.