Table/Matrix visual to collapse and expand visuals

Hi Anonymous ,

Suppose you have the following data.

1. Then you can first unpivot the [Type] and [LineCode] columns. 

2. Create custom column.

Amount = if [Attribute] = "Type" then [TypeAmount] else [LineCodeAmount]

3. Create a matrix visual and add the following fields.

4. Turn off the "Stepped layout" option.

5. Turn off the row subtotals for the Attribute column and the Value column. And set the position of the totals to the top.

Then you can click on the expand/collapse symbol in front of the [Date] column.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.