Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a matrix looks like the below
Is there a way I can only showing the Project A, Project B, Projecct C, Project D, etc. on the
GROUP MS row?
Currently it's a value in the column.
You can modify the dax to look for HASONEVALUE([Project Field Name]) - which will return yes in the lower heirarchy, and no in the group MS row.
e.g. IF(HASONEVALUE([Project Field Name]), BLANK(), [Your Project Measure or Value])
Thanks Vicky. I think this is what i want to use. Two issues
1) For the variable [Your Project Measure or Value] -> i can't actually put in any column value (it can only be measure, like min or maxing something)
2) Once I added this value into the Values of the matrix. I lose all the child rows, i.e., after i expand the MS group, there are nothing in side.
Thanks!
1) you will then need to sumamrize, or use SELECTEDVALUE([ColumnName]) if there's only 1 value per row
2) i'm a bit confused - didn't you just want the values in the upper-level of the groups? you can replace BLANK() with whatever you want to see in the children rows.
@GAPER , You have to use that in the row as the first value.
Or use as second Value and expand
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
I want it as a column. Not groupped under the rows.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.