Forum Discussion

FelixGolllner's avatar
FelixGolllner
New Member
3 years ago

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.

 

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

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      FelixGolllner
      New Member
      3 years ago

      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