{"id":1339,"date":"2023-04-04T22:01:01","date_gmt":"2023-04-04T20:01:01","guid":{"rendered":"https:\/\/data4success.de\/?p=1253"},"modified":"2024-05-27T06:48:40","modified_gmt":"2024-05-27T05:48:40","slug":"how-to-display-measures-in-a-matrix-in-power-bi-at-line-level","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/how-to-display-measures-in-a-matrix-in-power-bi-at-line-level\/","title":{"rendered":"Power BI: Display measures in rows"},"content":{"rendered":"<p>Power BI is a powerful business intelligence tool that allows you to connect, transform and visualize data from various sources. One of the most common visualizations in Power BI is the matrix, which provides a tabular representation of data with rows, columns and values.<\/p>\r\n\r\n\r\n\r\n<p>When you use measures in a matrix, they are displayed as values in the columns by default. However, this can sometimes be cluttered or inappropriate depending on what type of data you want to display. For example, if you want to create a contribution margin calculation that shows different items below each other at row level.<\/p>\r\n\r\n\r\n\r\n<p>In this blog post, I will show you how to display the measures in a matrix in Power BI at row level by using a simple option in the formatting area. This is useful if you want to compare multiple measures for a single category or if you want to create a hierarchical structure of measures.<\/p>\r\n\r\n\r\n\r\n<p><strong>Step 1:<\/strong> Create a matrix with the desired fields<\/p>\r\n\r\n\r\n\r\n<p>First, you need to create a matrix with the fields you want to display. In my example, I'm using the retail analytics sample data from Microsoft Dynamics 365. I want to display the sales values by item category using the following measures:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Average unit price<\/li>\r\n\r\n\r\n\r\n<li>Sales in the last year<\/li>\r\n\r\n\r\n\r\n<li>Sales this year<\/li>\r\n\r\n\r\n\r\n<li>Value<\/li>\r\n\r\n\r\n\r\n<li>Destination<\/li>\r\n\r\n\r\n\r\n<li>Status<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p>I drag the Element &gt; Category field to the row axis and the Measures to the value axis. Power BI automatically creates a matrix like this:<\/p>\r\n\r\n\r\n\r\n<p><strong>Step 2:<\/strong> Activate the \"Show in rows\" option<\/p>\r\n\r\n\r\n\r\n<p>As you can see, the measures are displayed as values in the columns. To display them at the row level, we need to enable an option in the Formatting area. To do this, select the matrix and click the Brush icon in the Visualization area. Scroll down to the Values section and enable the Show in Rows option. In the new formatting panel you will find this option under the Layout section.<\/p>\r\n\r\n\r\n\r\n<p>Once you have activated this option, the measures are automatically displayed on the X axis:<\/p>\r\n\r\n\r\n\r\n<p><strong>Step 3:<\/strong> Format the matrix according to your wishes<\/p>\r\n\r\n\r\n\r\n<p>Now you can format the matrix according to your needs. For example, you can change the order of the measures by rearranging them in the Columns area. You can also adjust the font size, color and alignment of the cells. You can also add or remove headers and totals rows.<\/p>\r\n\r\n\r\n\r\n<p><strong>Conclusion<\/strong><\/p>\r\n\r\n\r\n\r\n<p>In this blog post, I showed you how to display Measures in a matrix in Power BI at row level. This is a simple and useful option to present your data in a clearer and more fitting way.\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>Power BI ist ein leistungsstarkes Werkzeug f\u00fcr Business Intelligence, das es Ihnen erm\u00f6glicht, Daten aus verschiedenen Quellen zu verbinden, zu transformieren und zu visualisieren. Eine der h\u00e4ufigsten Visualisierungen in Power BI ist die Matrix, die eine tabellarische Darstellung von Daten mit Zeilen, Spalten und Werten bietet. Wenn Sie Measures in einer Matrix verwenden, werden diese [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1408,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-1339","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1339","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=1339"}],"version-history":[{"count":1,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1339\/revisions"}],"predecessor-version":[{"id":2464,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/1339\/revisions\/2464"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/1408"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=1339"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=1339"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=1339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}