Forum Discussion
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?
1 Reply
- Greg_Deckler
Community Champion
Anonymous 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.
