Forum Discussion
Different units in same column.
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.
2 Replies
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
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.
