Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
walnei
Helper III
Helper III

Formatting on Each Line of the Matrix

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?

 

Print PBI.png

Thank you so much!

 

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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")))

1.PNG

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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")))

1.PNG

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft

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

 

Tks

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.