Group multiple values from same and different columns

Hi Anonymous ,

Thanks for reaching out to the Microsoft fabric community forum. 

Please follow below steps:

Step 1: Load Your Data
In Power BI Desktop, load your sales data into Power BI. Go to Power Query Editor (Transform Data).

Step 2: Add a Missing Column for All Products :
Since your data has zero values for combinations that don't exist, you'll need to ensure all combinations exist (Date, Company, Currency, Product).

In Power Query:

Create reference tables for Date, Company, Currency, and Product. Use Remove Duplicates to create unique value lists.

Create a cross join to generate all combinations (e.g., with a custom step using Table.AddColumn). Merge this master combination table with your actual data to bring in values (with nulls for missing rows). Replace null in the Value column with 0.

Step 3: Add a Matrix visual.

Set up the fields like this:

Rows --->Date
Columns -->Company → Currency → Product
Values -->Sum of Value

Top level: Company

Under Company: Currency

Under Currency: Product

You can turn Subtotals on or off per level (like per Currency or per Company). Rename columns/headers using DAX or calculated columns if needed for cleaner display.

With the matrix set up, Power BI will automatically: Fill missing combinations with 0 (assuming you handled that in Power Query). Aggregate values as needed.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards