Need help

[FelixGolllner]

Hi,

I'am building a matrix with the following structure.

Visits (no split), Product (A, B,C) and sales (Product A,BC,D,E)

Therfor I have three main categories and 8 subcategories.

When I do it now with groups and I show the last level all subcategories are shown for all groups.

How can I manage this?

Thanks a lot

[amitchandak]

@FelixGolllner , Based on what I got

Create a new matrix visual
Add the Visits to the Rows of the matrix.
Add the Product, subcategories to the Columns of the matrix.
Add the Sales to the Values of the matrix

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[FelixGolllner]

Hi! Thank you! But my problem is that not all categories are supposed to be shown but it happens. Here an expample. The tool repeats the columns even if there is no value. The metric BIDI should not be shown under the position of one product. Thanks a lot for your help