Dynamic Slicers

[Anonymous]

I want to achieve the below requirement.

My data modal looks like this.

Fact Table-

Source	Product	rx_type	metric_name	Indication	Channel	SKU	Sub-Product
SQL	A	TRx	Paid TRx	15MG	PS
SQL	B	TRx	Paid TRx	30MG	PS
Azure	C	TRx	On Hand Qty		Big 3	P
Azure	C	TRx	On Hand Qty		Big 3	Q
Azure	C	TRx	On Hand Qty		Big 3	R
GBQ	D	TRx	AES Sales Qty	ALL - Direct Customers		74105001	X
GBQ	E	TRx	AES Sales Amt	ALL - Direct Customers		74105001	Y

Mapping Table-

Source	Mapping Column Names
SQL	Indication
SQL	Channel
Azure	Channel
Azure	SKU
GBQ	Indication
GBQ	SKU
GBQ	Sub-Product

I need to create three slicers namely out of which only one slicer for Source, is static and other two slicers should be dynamic.

It should be like- If I select SQL from Source Slicer, other two slicers should be Indication & Channel (As you can see from the mapping table).
If a user selects Azure from Source Slicer, other two slicers should be Channel & SKU (As you can see from the mapping table).

This is how it should be.

Is there any way I can achieve this kind of dynamic slicers?

[PijushRoy · Accepted solution]

Hi @Anonymous 

Please find the pbix file link
https://drive.google.com/file/d/1GxmLlpSF_Ah-zupgllVObhmPw4idFwZq/view?usp=sharing

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin