Formatting on Each Line of the Matrix

[walnei]

Friends, have some way to put in the array (print) each line with a type of formatting. Example in print.

In the% ABL line would have to be in percentage.

On the ATC Line it would have to appear in decimal

In the LED Line if it is 1 then it changes "yes", 0 changes to "no"

Do you know if it's possible?

Thank you so much!

[v-yuezhe-msft · Accepted solution]

Hi @walnei,

You can create a measure to contain logic that determine if the INDICATOR equals to a specific value and then format the Values field. Below is an example for your reference.

Measure = IF(LASTNONBLANK(Table1[INDICADOR],"")="%ABL",FORMAT(SUM(Table1[columnvalue]),"PERCENT"),IF(LASTNONBLANK(Table1[INDICADOR],"")="ACT",FORMAT(SUM(Table1[columnvalue]),"Fixed"),IF(AND(LASTNONBLANK(Table1[INDICADOR],"")="LED",LASTNONBLANK(Table1[columnvalue],"")=1),"Yes","No")))



However, the values you format will be defined as text type in Matrix visual, and it doesn’t make sense. From my point of view, it is better to change the format of the values in your original tables.

Thanks,
Lydia Zhang

[walnei]

@v-yuezhe-msft

One more question.How to do to put as a thousand, putting a point. Example. 5154,56 to 5.154

Tks

[walnei]

Spectacular, thank you ... You saved me! Hug!!!!