Format of number

[Barculez]

Hi,

i would like to ask you for help with format of number in the table.

My problem is, that i want to see some data as number and some as percentage. Is it possible? 

I tried some ways, but still got problem to find out.

Thank you very much

Barbora 

[Thejeswar · Accepted solution]

Hi @Barculez ,

If you set your column data type to text, you can have both Numbers and Percentage in it.

But if you want to calculate using something and arrive at this, you might consider using some if condition and concatenat '%' symbol. But you need to try this to know if this will work.

Other option is you have two tables once with percentage values and other will Numbers. Append those tables and get your final table. Column data type should be text

Regards,

[v-yangliu-msft · Accepted solution]

Hi  @Barculez ,

Power bi does not support different data formats in the same column, this is the design of Power BI, but you can use the Format() function in Dax to customise the formatting of the data if you can accept that the column will be in text format and you only need to have the two data formats displayed in the column, which will not be used to perform aggregation operations.

Refer to:

FORMAT function (DAX) - DAX | Microsoft Learn

Column =
IF(
    'Table'[ID]<=3,
    FORMAT('Table'[Value],"General Number"),
    FORMAT('Table'[Value],"Percent"))

Best Regards,

Liu Yang

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

[Thejeswar · Accepted solution]

Hi @Barculez ,

If you set your column data type to text, you can have both Numbers and Percentage in it.

But if you want to calculate using something and arrive at this, you might consider using some if condition and concatenat '%' symbol. But you need to try this to know if this will work.

Other option is you have two tables once with percentage values and other will Numbers. Append those tables and get your final table. Column data type should be text

Regards,