- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Pivot table into a matrix with measures
I have three tables: cash indicators, key - invoice; physical indicators (volumes), key = class; planned indicators, key = class + category. All tables have a date, so key + date.
In the table of financial indicators, the initial fields are invoice and value, the rest were added for categorization.
Example of source table structure
I want to combine this all into a P&L table. Include monetary indicators, physical indicators and compare it all with the planned ones. For this I planned to use measures.
I encountered a problem: I was only able to link cash indicators and planned indicators; or connect physical and monetary, where I was able to add indicators such as price.
Planned final view
I don’t understand whether I can, in principle, implement such a report; how can I add measures to both rows and columns?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Y_a_D
Do you mean that you want to create a matrix with custom headings, the first rows are ‘Without_class’, ‘class_1’, ‘class_2’, and all contain fact and plan. which all contain fact and plan.
You might consider looking at the following link, where you need to create the various measures to be put into the matrix ahead of time, and then create a hierarchical table of headings, and use the Switch() function to customise the rules to determine which measures correspond to a given heading:
Solved: Matrix column header/label custom group - Microsoft Fabric Community
This is the related document, you can view this content:
https://community.fabric.microsoft.com/t5/Desktop/Add-a-delta-column-in-matrix/td-p/2935739
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
08-08-2024 09:09 AM | |||
02-05-2024 06:46 AM | |||
03-01-2023 07:13 AM | |||
07-26-2024 12:47 AM | |||
05-21-2024 04:55 AM |
User | Count |
---|---|
84 | |
79 | |
63 | |
51 | |
30 |
User | Count |
---|---|
115 | |
114 | |
71 | |
66 | |
39 |