Forum Discussion

microsoftrookie's avatar
microsoftrookie
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Removing Decimals in a measure

Hello, In my report I have visualizations that are in measures since I am not able summarize or total any of my data because they would be inaccurate. My measures all follow the same format; measure...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    You should be able to change your measure format to Whole Number or set your decimal places to 0. This would be on the Model tab.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

You should be able to change your measure format to Whole Number or set your decimal places to 0. This would be on the Model tab.

microsoftrookie's avatar
microsoftrookie
Icon for Advocate II rankAdvocate II
8 years ago

Thank you for your quick reply,

However, in the query it is already set to being a whole number so that is not the problem; and the modeling and changing the type does not work because I cannot change a measure from being a whole number in the modeling tab because it recognizes the measure as having text type data because the measure is an if statement with a text type ,,false format. 

I did not think it would be possible to lose these decimal points, because it technically is neither text nor number but rather it floats between the two.

Thank you again however for your speedy reply,

Regards,

Microsoft Rookie