Display DAX Measures in a Matrix on Rows

This post is also available in: Deutsch

Measures are the best way to calculate your key figures in Power BI. In a matrix, however, these can normally only be displayed as values and not at row or column level. However, sometimes you need them exactly at the row level.

Display contribution margin calculation at row level

An example I came across recently was the presentation of a contribution margin calculation. I already apologize if the English terms are not translated correctly, my original calculation was in German ? . The individual items should be displayed below each other at row level. The default view, when displaying only the Measures, is horizontally aligned:

Standard display of measures in matrix in Power BI
Standard display of measures in matrix in Power BI

Even if you explicitly drag the measures onto the rows, they cannot be displayed at row level:

Measures cannot be dragged onto lines
Measures cannot be dragged onto lines

There is, however, an option which is rather unknown, but which makes this possible very easily: the option “Show on rows” in the Matrix Visual:

Option "Show on rows" enables desired display
Option “Show on rows” enables desired display

As soon as this option is activated, the measures are automatically displayed on the X-axis:

Display of measures at row level
Display of measures at row level

In my example, the use of custom visuals was not allowed. Otherwise, there are some other options as an alternative.

Denis Selimovic

Denis Selimovic

As a user from the very beginning, Denis Selimovic is passionate about Power BI and everything related to it. In his blog WhatTheFact.bi, he writes about the latest developments in Power BI and provides tips and tricks on the subject. Besides being a Power BI enthusiast, blog author, speaker and senior consultant, he is also co-organizer of the Meetup Power BI User Group Switzerland.

Kommentare:

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x