Rename values in a measure and use it as a row in matrix

[Anonymous]

Hello, 

I work on Power BI with Direct DB Connexion.

I wanted to just rename values contaned in a column, and display it in a matrix as a row. For a translation for example.

SPA = If selectedvalue(ENG)= "Flower", "Flores

In a table, it works:

ENG | SPA | Number

Flowers | Flores | 18

But it does not allow me to use SPA as a row in a matrix. Can I get it to work somehow?

[Anonymous · Accepted solution]

Hi @Anonymous ，

This is due to the fact that by design, metrics need to act on the context, so placement on the rows of the matrix is not supported.

You can create a column to be placed on the rows of the matrix.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Yes I think it's not supported in Matrix. I cannot add a column because it's a direct connection. I asked people in the datasource side to add the column I need in the Database.

Thanks

[vicky_]

You'll need to provide more details - is there any error messages appearing when you try to use that measure? It seems to me that your code should work fine.

[Anonymous]

I have no errors: when I drag & drop, it does nothing. When I use it in a table, and change the table to matrix, the indicator moves auto to values.