The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |