clasiffy in more than one field

[afrutos]

Hello good afternoon, I have a question that I can't solve.

Can I classify a field in 3 or 2 classifications at the same time?
Let me explain:

I have a field that returns me the status of the invoice taking into account the credit note; if an invoice is collected and has pending to execute the credit note, I would like to classify at the same time in collected and in pdte of collection,
can this be done?

 Thanks in advanced

[v-jingzhang · Accepted solution]

Hi @afrutos 

You can first use Power Query Editor to transform the raw data into below structure:

Then use a Matrix visual to display the result. 

Transformation steps are:

1. Add three custom columns with Text.Contains function to decide whether an invoice belongs to a classification. 

= Text.Contains([Etiquetas de fila],"FACTURA COBRADA")

= Text.Contains([Etiquetas de fila],"ABONO COBRADO") or Text.Contains([Etiquetas de fila],"ABONO EJECUTADO")

= Text.Contains([Etiquetas de fila],"NO COBRADO") or Text.Contains([Etiquetas de fila],"NO EJECUTADO")

2. Unpivot the above three columns.

3. Change the logic Value column to Text type. Replace true/false values with the values you want to display. 

I have attached the sample file at bottom. You can download it to find details. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[afrutos]

Finally it works correctly, thanks!