Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dynamic Slicers

I want to achieve the below requirement.

My data modal looks like this.

Fact Table-

SourceProductrx_typemetric_nameIndicationChannelSKUSub-Product
SQLATRxPaid TRx15MGPS  
SQLBTRxPaid TRx30MGPS  
AzureCTRxOn Hand Qty Big 3P 
AzureCTRxOn Hand Qty Big 3Q 
AzureCTRxOn Hand Qty Big 3R 
GBQDTRxAES Sales QtyALL - Direct Customers 74105001X
GBQETRxAES Sales AmtALL - Direct Customers 74105001Y

 

Mapping Table-

SourceMapping Column Names
SQLIndication
SQLChannel
AzureChannel
AzureSKU
GBQIndication
GBQSKU
GBQSub-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?

Show and Tell