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.
I'm using new matrix since it allows to click and filter the page elemnts (not possible in other matrixs).
To have a flat format, I put all my fileds in value group insted of row goup, but this seems to change some information.
LAYOUT 1
PM field in in the row goup
WORK_ID = 1035
PM = Casabianca Giovanni (correct)
LAYOUT 2
PM field in in the column goup
WORK_ID = 1035
PM = Alvino Stefania (correct)
WORK_ID and PM are fileds of different table with a relationship 1-1.
In your second image, if you put the PM field in Value box, this field will be aggregated so that it will show the incorrect data. You should put it in Row Group. However, it will be populated into next level within same column. Since you need a flat format, I suggest you still use table visual and use a sclier to filter data. I suggest you post a feature request on idea.
Regards,
I take your point about putting the filed in the VALUE box and the aggregation bahaviour.
However, for each value in the ROW group there is only one corresponding value for fileds in VALUE group and the aggregation should return the correct value.
It could be a mistake in data selection of the New Matrix
Regards
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.