Different units in same column.

[Anonymous]

Hello, 

I am starting in the world of PowerBI. I am building a report in PowerBI Desktop and importing the data in DirectQuery with SQL.
When creating the matrix with the report, EACH column has some rows with % (percentages) so I cannot format the entire column with the same unit.

I would like to know if I can format only the columns I want with % and put the rest with decimal values, both positive and negative (in brackets).

Thanks for your help, I appreciate any kind of help.

[Anonymous]

@amitchandak thanks for your quickly response.

I tried entering a new format in the Modeling view, following the instructions on the page, but nothing happens.

I don't know if this is the correct procedure, because I don't have much experience with this type of modification.

Thank you again for your time and your response.

[amitchandak]

@Anonymous , You have use format function based on condition

if(Max(Table[P&L Category]) = "Benchmark", format([Measure], "percent") , format([Measure], "decimal") )

check more option

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings