How to use SELECTEDVALUE of one slicer to change a second slicer ?

[morani]

Hi,

I have a slicer where the user can select between TotalUnits and TotalGrossSales (both are measures):

This slicer was created using Dynamic measure (that was created with Field parameters - that includes measures TotalUnits and TotalGrossSales). 

I have the following 8 measures:

PriorDayUnits

PriorWeekUnits

PriorMonthUnits

PriorYearUnits

PriorDayGrossSales

PriorWeekGrossSales

PriorMonthGrossSales

PriorYearGrossSales

I want to create a second slicer that will change based on the user selection in the first slicer.

It will show:

PriorDayUnits

PriorWeekUnits

PriorMonthUnits

PriorYearUnits

When the user chooses:

and display

PriorDayGrossSales

PriorWeekGrossSales

PriorMonthGrossSales

PriorYearGrossSales

When the user chooses:

How can I do it using SelectedValue(). Note that the first slicer selects between two measures. 

Thanks for your help!

[johnt75]

Create a second field parameter to use in the second slicer, if you don't have one.

You can then create a measure to use as a filter on the second slicer. You can't use SELECTEDVALUE on a field parameter name, you have to use the order, so it would be something like

Second param is visible =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Param 1'[Order] ) = 0
        && SELECTEDVALUE ( 'Param 2'[Order] ) IN { 0, 1, 2, 3 }, 1,
    SELECTEDVALUE ( 'Param 1'[Order] ) = 1
        && SELECTEDVALUE ( 'Param 2'[Order] ) IN { 4, 5, 6 }, 1,
    0
)

Add this measure as a filter on the second slicer, set to show only when the value is 1

[morani]

Thank you so much @john75 , it worked. The trick of using the order solved it 

[v-menakakota]

Hi @morani ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

 If this is the solution that has worked for you consider marking Accept as solution to assist other members in finding it more easily.

Thank you and Regards,
Menaka Kota.

[v-menakakota]

Hi @morani  ,

I hope the provided 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-menakakota]

Hi @morani ,

We really appreciate your efforts and for letting us know the update on the issue.

Please continue using fabric community forum for your further assistance.

 If this is the solution that has worked for you consider marking Accept as solution to assist other members in finding it more easily.

Thank you and Regards,
Menaka Kota.