Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
GAPER
Post Patron
Post Patron

How not to show values for sub items

I have a matrix looks like the below

 

GAPER_0-1696990452296.png

 

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. 

5 REPLIES 5
vicky_
Super User
Super User

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.

amitchandak
Super User
Super User

@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.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I want it as a column. Not groupped under the rows. 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors