Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unable to change Rounding

Hello Community,   Can someone please let me know why the 'Rounding' is greyed out. I would like to change the rounding to 0 decimal places but I'm unable to, see image.  
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    We should change the data type to Percentage.Type firstly. Then we can decimal places in Modeling.

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtEzVlWK1cFgxAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [percentage = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"percentage", Percentage.Type}})
in
    #"Changed Type"

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

I would just make that change in the model layer in PowerBI using formatting rather than in PowerQuery.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi JD,

 

I tried your suggestion, but unfortunately, the format is Greyed out 'not available'

 

Can you think of any reason why that is?

 

 

Unfortunately, for some reason I'm unable to show you a photo / screenshot - the uploading of photos here in Desktop Forum is not available.

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Hi Anonymous 

    You do still need to change the datatype in PowerQuery to decimal number.  Then when it is in the model you do the formatting to remove the extra digits on the %.  What does the Date Type show in PowerBI desktop?