Forum Discussion

bruleyn's avatar
bruleyn
Advocate I
9 years ago
Solved

Changing data type/display based on column

I would like to display data on the same graph but change the filter to display individual rows of data. Some rows may have values as numbers and some as percents. Is there a way to tell PowerBI to d...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi bruleyn,

    We can not set the same column in different format, if you want to add the % in the column using the formula below, the type will be text. You can not use text data type in value field. 

    Percentage = CONCATENATE( Table1[Column2]*100,"%")




    So for your requirement, we can not displysame column in different format.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi bruleyn,

We can not set the same column in different format, if you want to add the % in the column using the formula below, the type will be text. You can not use text data type in value field. 

Percentage = CONCATENATE( Table1[Column2]*100,"%")




So for your requirement, we can not displysame column in different format.

Best Regards,
Angelia