Change the column in a slicer view based on the slicer value

[Anonymous]

We have one Dimension table called Product_ Dim and there are two attribute columns "Product Category" and "Product Subcategory"

We have to create two slicers. 

First slicer "Select Column" which will be a single select slicer  and should be populated with two rows or values such "Category" and "Subcategory". User would select either "Category" or "Subcategory" from this slicer.

Based on the selected value, we have to create another slicer which would show actual column values (multiselect) of "Product Category" or "Product Subcategory"

[Anonymous]

Hi,

Thank you.  But in our case, in slicer 1, we would need to populate 2 dummy values (Category and Sub Category) and based on the selection in the slicer 1, in another slicer (slicer 2), an actual column should open (Product Category and Product Subcategory)

Yes with bookmark we are able to achieve this functionality. But is there any DAX function we can use to implement this requirement ?

[v-chenwuz-msft]

Hi @Anonymous 

As far as I know, there is no similar dax.

Best Regards

Community Support Team _ chenwu zhu

[v-chenwuz-msft]

Hi @Anonymous ,

I think you can consider using bookmark for this function.

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.