Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Item Mix Visualization

so i have 4 columns of binary data    i want to be able to filter through the combinations of the 4 how can i do that? ie if i have product 1 and product 2 vs having all 4 products?   when i t...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

i have 4 items i need combinations of it sounds like this would be listing out all 24 combinations for separate revenue 

 

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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    thats the thing if you write out all the combinations like that it doesnt scale

     

    this treemap for combinations should be very simple 

     

    perhaps its my set up