Catch slizer selection when not used as filter

[Anonymous]

Hi,

I wish to catch the selection in the slizer enventhough the slicer is not filtering the target context. In the image below i would like to take the selection in the slicer and limit the displayed values to all months before the selected valule. How would you do that?

[v-eachen-msft]

Hi @Anonymous ,

At first, you should use correct format. "CY2014-Aug" is text type value and you cannot sort directly.

Solution1 :
You could change it to be number or date type( like "201408" or "08/01/2014").

Then you could use slicer to get the range.

Solution2 :

You could also create a new table with the month column(number or date type) and use it as your slicer.

Then use SELECTEDVALUE() function to get your selection with a measure and use CALCULATE() function to get value before your selected value.

Solution3 :

If your origin table has a correct sort, you could add an index column and use it as a slicer.

[Anonymous]

Hi,

The slizer is required to have Month-Year periods listed and it is required to be a drop-down. I want to use the selection to limit the time-axis but has yet to find a viable solution to catch the selection in the chart . SELECTEDVALUE will not give you the value of the slizer if the slizer is not in context as shown. And,  if it is in context the time-axis will be limited to show the selcted month.