cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saxon10
Post Prodigy
Post Prodigy

Measure in matrix row level

 

I have a two columns in data table which is area and result. I created new measure in same table which is status and I would like to bring it the area in column level, result in value column and new measure (status) row level in matrix visual table.

 

AREA

RESULT

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD1

WIN

DD2

LOSS

DD3

LOSS

DD3

LOSS

DD3

LOSS

DD3

LOSS

DD4

LOSS

DD5

LOSS

DD6

LOSS

DD7

LOSS

DD8

LOSS

 

Saxon10_0-1627680965126.png

 

 

Saxon10_0-1627680683502.png

 

1 ACCEPTED SOLUTION
sevenhills
Impactful Individual
Impactful Individual

You cannot add a measure in matrix row. (Like @Mohammad_Refaei said )

Have you every looked into "Show on rows" functionality for your needs? Just curious. 

View solution in original post

7 REPLIES 7
sevenhills
Impactful Individual
Impactful Individual

You cannot add a measure in matrix row. (Like @Mohammad_Refaei said )

Have you every looked into "Show on rows" functionality for your needs? Just curious. 

View solution in original post

Thanks for your reply. I tried the option and its works for value column not im row level. 

sevenhills
Impactful Individual
Impactful Individual

It has limitations and not work for all scenarios.
Shared so that it is worth a look and see if you could change your visualization.
Sorry, if this does not help your scenario. 

Hi,

 

Thanks for your response and update. 

sevenhills
Impactful Individual
Impactful Individual

I was thinking about your request and thought will share this article. Not sure whether this fits, worth a read

 

 

https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/


Basically, the article talks about and bridges some of the issues we normally encounter. Check it out and see if it fits for your needs.

 

 

Mohammad_Refaei
Solution Specialist
Solution Specialist

You cannot add a measure in matrix row.

You have to add a data field (column).

thanks for your quick response. 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!