Forum Discussion

morani's avatar
morani
Icon for Helper I rankHelper I
1 year ago

Change slicer fields based on a different slicer selection

HI all,   I have 8 measures:  ("PriorDayUnits"), ("PriorWeekUnits"), ("PriorMonthUnits"), ("PriorYearUnits") under field parameters called Comparison1 and ("PriorDayGrossSales"), ("PriorWeekGr...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

1. Make sure your first field parameter slicer is set to single select

 

2. delete all the other measures and create new measures that probe the SELECTEDVALUE of the first slicer and compute the required results.

  • morani's avatar
    morani
    Icon for Helper I rankHelper I
    1 year ago

    Hi Ibendlin,

     

    Thanks for your answer. Can you please let me know how to create the new measure that probe the SELECTEDVALUE of the first slicer (TotalUnits or TotalGrossSales) and will change a second slicer to display ("PriorDayUnits"), ("PriorWeekUnits"), ("PriorMonthUnits"), ("PriorYearUnits") if  TotalUnits is selected in slicer 1 or ("PriorDayGrossSales"), ("PriorWeekGrossSales"), ("PriorMonthGrossSales"), ("PriorYearGrossSales") if TotalGrossSales is selected in slicer 1?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Use SELECTEDVALUE or VALUES.  that will give you a single column table that you can use directly as a filter.