Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I got this Matrix with this information:
And i would like to have the information on the row. For exemple this:
But I don't know what to put in my rows to have this because I dont have a column with those 3 names in my power bi.
Do you know how to do it?
Thanks
Solved! Go to Solution.
@Anonymous,
Value =
VAR SelValue =
SELECTEDVALUE ( Table[MeasureName] )
RETURN
SWITCH (
TRUE (),
SelValue = "Production", SUM ( MainTable[Production] ),
SelValue = "Sant Effet", SUM ( MainTable[Sant Effet] ),
SelValue = "Production nette", SUM ( MainTable[Production nette] )
)
3. Add MeasureName to Rows and Value Measure to Column
It will work.
@Anonymous,
Value =
VAR SelValue =
SELECTEDVALUE ( Table[MeasureName] )
RETURN
SWITCH (
TRUE (),
SelValue = "Production", SUM ( MainTable[Production] ),
SelValue = "Sant Effet", SUM ( MainTable[Sant Effet] ),
SelValue = "Production nette", SUM ( MainTable[Production nette] )
)
3. Add MeasureName to Rows and Value Measure to Column
It will work.
@SivaMani Thank you but if I do it, the matrix will not be changing with a filter in my report right?. For exemple if I change a filter in my report it would not calculate again my measure Production, Sans Effet and Production nette and display the correct values. It will display the old values. To information, my 3 measures can be filter thanks to 2 columns, columns "X" and "Y". Can we had a line of code in your code to allowed the matrix to recalculate the values whena filter changed?
Thanks
HI @Anonymous ,
Under ROWS section you can move only a column.
Do you have something in your data like a categorical column with 3 values as categories that you have moved the measures for?
I am assuming that under VALUES section you moved 3 measures.
Thanks,
Pragati
@Pragati11 Hello, no as my 3 values are measure I don't have a categorical column with my values name.
HI @Anonymous ,
In that case follow the solution mentioned by @SivaMani using the approach of a disconnected table.
Thanks,
Pragati
@Pragati11 ok thank you, but as I reply to him it will not re calculate my values if I change the filters no?
@Anonymous, Don't worry!
The report filters will filter the data and measures will recalculate accordingly.
Thank you its working!
@Anonymous, you're welcome🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |