Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
For example a report of invoices with the articles that belong to the invoice below the invoice number as a list, without 'Invoice 1" being repeated on every article line:
Invoice 1
article 1 €5
article 2 €6
Invoice 2
article 1 €3
article 2 €3
How can make such a report in Microsoft Power BI?
You are looking for that classic Pivot Table look in Compact Form however we don't have this look yet.
Vote here if you'd like to improve the Matrix.
Idea 1
Idea 2
@RHAD Sounds like you want a matrix. Here is the sample data set
and here is what it looks like by dropping it in a matrix (I removed the total columns in formatting) These are 2 examples on the same data set, one by invoice only, the other with article. The data will automatically aggregate depending on what fields you have in the matrix.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |