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

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.

Reply
Anonymous
Not applicable

Matrix help

Hi, 

 

I am wanting to include this measure in the "row" section of my matrix: 

 

metric.PNG (this is an excel example)

 

Here is what I have in Power Bi currenlty:

 

metric 1.PNG

 

It sems to be a fact that i am unable to create a measure and include it as a roe in the matrix. -- My guess is to create a calculated column that takes the variance of leads to units; but I am having trouble creating this. 

 

Here is an example of my source dataset:

 

metric 3.PNG

 

 

 

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@Anonymous,

It is not possible to drag measures in Rows of Matrix visual in Power BI Desktop, there is an idea about this issue, please vote it up.

In addition, you can create a disconnected table to work around this issue, for more details, please review the following similar blog.

http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vega
Resolver III
Resolver III

If it is just one measure then it will not show on rows. If you have more than one you can put the measures in the rows. You can read about it here:

Anonymous
Not applicable

This is not giving me the result I need; I have measures that I need to remain in the column format:

 

metric4.PNG

 

The red values are measures that need to remain in this format; I want to include the additional conversion of Leads to Started Units as a row value

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.