Item Mix Visualization

Hi Anonymous,

---

i was hoping to be able to use a treemap so you could select the combinations better and accounting for these different combinations would happen behind the scenes automatically like when im selecting different regions for sales data across the states

---

Is your expected result similar like below?

If so, you can firstly use the formula provided by Phil_Seamark above to add a calculate column to your table.

mix = 'Table1'[Item1] & "," & 
		 'Table1'[Item2] & "," &
		 'Table1'[Item3] & "," & 
		 'Table1'[Item4]

Then, you can use the new create calculate column as Group on the Treemap, and use the four Item column as Slicers to get your expected result on the report.

Here is the sample pbix file for your reference. :smileyhappy:

Regards