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...
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.