How to make a Column based Filter/Pie Chart

[derekli1700]

Store	Period	Vol (L)	PRODUCT 1	PRODUCT 2	PRODUCT 3	PRODUCT 4
Store A	Jan-24	211	211.00
Store A	Feb-24	250	250.00
Store A	Mar-24	315	295.00		20.00
Store A	Apr-24	354	354.00
Store A	Jun-24	679	679.00
Store A	Jul-24	927	884.00		43.00
Store A	Aug-24	645	539.00		106.00
Store A	Sep-24	392	392.00
Store A	Oct-24	677	560.00		117.00
Store A	Nov-24	403	369.00		33.00
Store A	Dec-24	78	78.00
Store A	Jan-25	101	101.00
Store A	Feb-25	249	249.00
Store B	Sep-24	441	441.00
Store B	Aug-24	496	459.00			37
Store B	Nov-24	568	559			9
Store B	Apr-24	726	697			29
Store B	Jan-25	738	713			25
Store B	Jul-24	919	874			44
Store B	Dec-24	980	980
Store B	May-24	1,053	967			87
Store B	Feb-25	1,218	1161			58
Store B	Oct-24	1,298	1298
Store B	Jan-24	1,375	1177		89	110
Store B	Mar-24	1,582	1301			281
Store B	Feb-24	1,785	1678			107
Store B	Jun-24	2,365	2365

Based off this data - how would i make a dropdown filter/Pie chart for Product 1,2,3,4 and have that affect the matrix table of data to see what store has had product x occur?

I'm assuming a measure or a unique product list is needed.

[v-priyankata]

Hi @derekli1700 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @derekli1700 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @derekli1700 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[ryan_mayu · Accepted solution]

@derekli1700 

maybe you can try select the first three columns in pq and unpivot other columns

then you can just filter attribute column to select different product. 

if this does not work, pls proivde the expected output.

[derekli1700]

Hi - i seem to have replicated it but the addition of the values seem to have shifted:
New:

Old:

[ryan_mayu]

pls provide the expected output based on the sample data you provided 

[derekli1700]

Hi,

Apologies - i just applied it to my larger test dataset test3.xlsx

and noticed duplicate rows which may skew the volume column. Do you have a recommendation on how to remove them? Thanks!. Simply right clicking "remove duplicates" would remove some product rows so im assuming a custom column formula might be needed?

[ryan_mayu]

@derekli1700 

vol column is the summary of the 4 products. I think we don't need that column , you can remove it and select the first 2 columns and unpivot other columns