Forum Discussion
Need help
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. ...
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.
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