Display DAX Measures in a Matrix on Rows

This post is also available in: Deutsch

Update March 2022: Screenshot of the new format pane added

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. 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

In the new format pane you will find the option in the following spot:

Option "Switch values to rows" in new formatting window enables wanted layout
Option “Switch values to rows” in new formatting window enables wanted layout

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
1 Comment
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
sifar
sifar
5 months ago

Show on rows is not present in the latest power bi desktop version 🙁

1
0
Would love your thoughts, please comment.x
()
x
%d bloggers like this: