Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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.
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.
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
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.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |