Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

The percentage value is incorrect

When I get data (tekst/csv) in PBI the column has values like:  ​​32.6, 53.5 etc.

These are in PBI TEKST, but it should be %. 

When I change the type to percentage the values change to: 3260,00%, 5350,00%

How do I get it right?: 32,6%, 53,5%

  • hello Anonymous  hows your data column in csv looks like , if the column is not percentage type , then powerbi will think it decimle , or just do what miTutorials  told you and divide by 100

2 Replies

  • Divide the values by 100 and then change to Percentage.

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member

    hello Anonymous  hows your data column in csv looks like , if the column is not percentage type , then powerbi will think it decimle , or just do what miTutorials  told you and divide by 100