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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.