Power BI : Based on the user selections on filter 1 values to be displayed automatically in filter 2

[Anonymous]

Dear All,

The objective of the power bi dashboard is to compare two stock keeping units.

Source of data is the same for both the stock keeping units. also, the variables/ dimensions are the same.

For instance Dashboard imitation as below :

Drop down to select material type from SKU 1 and SKU 2 for comparison

SKU1                          SKU2

material_type             material_type

---------------              ---------------

1) Pepsi                     1) Pepsi

2) Coke                     2) Coke

Revenue                   Revenue

Shipping Cost     Shipping Cost 

Requirement:   IF pepsi is selected on the left hand side for SKU1 then the options that should be available on the right hand side on the SKU 2  selections should be "SAME" and "OTHER" (instead of Pepsi & Coke).

SAME means pepsi . which is actually selected on the left hand side. OTHER means Coke.

Likewise when Coke is selected on the left hand side for SKU1  then the options that should be available on the right hand side on the SKU 2 should be "SAME" and "OTHER" again. (instead of Pepsi & Coke).

This time  SAME Means Coke. which is actually selected on the Left hand side . Other means Pepsi.

[v-juanli-msft]

Hi @Anonymous 

It seems impossible to achieve this requirement with default slicer.

For any workaround, could you accept any custom visual or use a table visual as a slicer?

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.