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
Rajkumar07
Helper I
Helper I

Matrix Visual

Hi Team, 

I'm having a column based on that I want to show the four measure values accordingly in the below format. Could you please help me how to get this or is this possible to achieve.

Prodcut Account: BreakdownValues/ MeasureJan
  44927
Product ARevenue698095.78
 Cost542733.2
 GMD155362.58
 GMD (%) 0.222551954
Prodcut BRevenue124603.27
 Cost88224.97
 GMD36378.3
 GMD (%) 0.291953012
Product CRevenue822699.05
 Cost630958.17
 GMD191740.88
 GMD (%) 0.233063208
Product DRevenue300970.54
 Cost222363.9888
 GMD78606.5512
 GMD (%) 0.261176895
Account SupportRevenue0
 Cost7156.49
 GMD-7156.49
 GMD (%)  
1 REPLY 1
whitch
Resolver I
Resolver I

How about something like this:
MyNewMeasure = if(SELECTEDVALUE('tableName'[BreakdownValues])="Revenue",[Revenue],if(SELECTEDVALUE('tableName'[BreakdownValues])="Cost",[Cost],if(SELECTEDVALUE('tableName'[BreakdownValues])="GMD",[GMD], [GMD%])))

 

I'm assuming you already have [Revenue], [Cost], [GMD] and [GMD%] measures, and Revenue / Cost / GMD / GMD (%) are rows in some table (which I've just called 'tableName' in my measure).  If you don't have such a table, create one (but don't join it to anything).

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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