Have issues with using a matrix table

Hi alex20p 

Thank you for reaching out to the Microsoft Community Forum.

To build a grouped table in Power BI that mimics the Crystal Report style you shared with nested groups: Date → Vendor Name → Truck ID → Detail Fields**, here's a structured way to achieve it. 3 levels of grouping: Date > Vendor Name > Truck ID, Multiple detail fields displayed in a row-like format under each Truck ID, a total row or summary at the bottom.
Use Table Visual + Grouping in DAX, The Table visual is better suited for your case than Matrix when you want to show many fields side-by-side per row without aggregation.
Grouping Lines (Mimic Crystal’s Expand/Collapse):Power BI doesn't support native nested expand/collapse for tables the way Crystal Reports does, but you can mimic it:

Use a slicer or bookmark-based toggles to show/hide details or break the layout into multiple visuals per level (Date header, Vendor section, Details)

if you use matrix visual (Only if You Want Aggregated Data), if you're summarizing data (e.g., totals per vendor), you can use a Matrix with:

Rows: Date > Vendor Name > Truck ID

Values: Only measures (like sum of weight, volume, etc.)

But this won’t display raw fields side-by-side. It’s best for numeric summaries, not detailed row data.
If Power BI is showing only one value or blank in the Values area:

• Ensure your values are not aggregated unintentionally.
• Instead of putting fields in “Values”, put them in Table columns directly.
• If you must use Matrix, convert details into measures with SELECTEDVALUE() if needed:

DAX : Truck_Location = SELECTEDVALUE(Truck[Location])

Final Touch: Grand Totals

In the Table visual, to show totals like "Total Truck" row, Use a measure that dynamically changes label based on row context:

DAX : Truck_Label = IF(HASONEVALUE(Truck[Truck ID]),MAX(Truck[Truck ID]),"Total Truck")


If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
Thank you.