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...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Anonymous

 

So for the above example, what is your ideal result?  Can you also mock that up in Excel?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

 

i guess something like this where i am able to see the different impacts of item combination on this particular KPI

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    If you only have 4 columns as per your example you could just create a new calculated column like this

     

    mix = 'Table1'[Item 1] & "," & 
		 'Table1'[Item 2] & "," &
		 'Table1'[Item 3] & "," & 
		 'Table1'[Item 4]

    and then drag that to a Grid and sum your Revenue column.  I suspect your real example isn't so straight forward??

    • 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

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Hi Anonymous

         

        I'm keen to understand more about what you mean about selecting combinations.

         

        Feel free to DM me with a PBIX file with more detail so I can help more.