Forum Discussion

Nicky_12345's avatar
Nicky_12345
Frequent Visitor
3 years ago

Grouping products by Groups and Subgroups

Hi, please assist:

 

I need to create the below table as a Power BI visual:

Would the best way be to create/maintain a data table with 3 columns - Product, Subgroup & Group and then create a relationship between the product field between this new table and my dataset to pull through the relative sales contribution by Group/Subgroup?

POWER BI Reports in web application

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Nicky_12345 Difficult to say exactly. Use a Matrix visual, put Product Category and Product columns in your rows. Put your Categories column in your columns. Some measure as Value. Without example source data almost impossible to know exactly.