Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Formating a column in Percentage does get applyed in data model

Dear community,   I changed the data type of some columns to "Percentage" in Query Editor. After refreshing all values show up correct in the Query Editor. But after applying the changes in data mo...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Anonymous 

     

    My understanding is that the data storage type and the data visualization type cannot be completely consistent.


    For example, in power query there are duration, date/time/time zone, percentage type, which is not in power bi, but power bi can format the data as the above type.

    If you do not format the data, power bi needs to select a data type for the data first, with percentage as decimal, date /time/time zone as date, duration as decimal, etc.
    When you convert the data to percentage type in power query, but power bi can only treat it as a decimal, then you can format the data as a percentage to display the data.

     

    To make it easier to understand

     

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, Anonymous 

 

My understanding is that the data storage type and the data visualization type cannot be completely consistent.


For example, in power query there are duration, date/time/time zone, percentage type, which is not in power bi, but power bi can format the data as the above type.

If you do not format the data, power bi needs to select a data type for the data first, with percentage as decimal, date /time/time zone as date, duration as decimal, etc.
When you convert the data to percentage type in power query, but power bi can only treat it as a decimal, then you can format the data as a percentage to display the data.

 

To make it easier to understand

 

Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Team Zeon Zheng,

    thanks for your advice. But I still noch understand, why I should format the data to percentage in the Query Editor. In my case it would be sufficient to format the value as decimal in the Query Editor and format the column to percentage for the report view in the data model. But I can live this solution. CU