How to get different measures shown within one matrix

[Anonymous]

Hey everyone,

I want to create a multidimensional "P&L"-Like matrix within my Power BI Dashboard.

Therefore I have created different measures, with each of them representing one row within my P&L.

For example, the first measure calculates the "Revenue", the second measure calculates the "Cost of Sales", the third one calculates the "Gross Margin" and so on.

In terms of the columns, I have separated my matrix by different products, so that I can see the revenue for every single product next to each other.

My problem is:

How do I get the different measures (as mentioned before) into my matrix? Every measure should be represended within one row, but it does not seem to be possible.

Does someone have any advice here? Maybe I can write the results of the measures within a new table, so that I can use this new table for my matrix?

Looking forward to your advice here!

Regards,

[amitchandak]

@Anonymous , are you looking for a measure slicer? Selected measure to display in matrix

if yes, refer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

[Anonymous]

Hey,

thank you very much for your answer!

Unfortunately, that is not exactly what I am looking for.

The table that I described in my initial message should be shown permanently and I do not want to change the content of it by using a slicer.

My problem is, that I cannot select more than one measure to be shown within the different rows.

It should look like this:

	Product I	Product II	Product III
Revenue	Result Measure I	Result Measure I	Result Measure I
Cost of Sales	Result Measure II	Result Measure II	Result Measure II
Gross Profit	Result Measure III	Result Measure III	Result Measure III
...	...	...	...

[amitchandak · Accepted solution]

@Anonymous , Enable show on row and take the product of column, nothing on row and measure on values and you have use calculation groups for multiple measures

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[Anonymous]

Yes, that did the trick!

Thank you very much!