Filter a visual based on max slicer value

[Anonymous]

Hi, 

I have a month number slicer which I use to get data from the start of the year until the month I selected :

However, on the same page I have visuals which I would like to filter on the last month of the selection I made on the slicer. 

e.g. I have selected months 1 to 3 on my slicer and I would like to have a pie chart showing only data from March, and I want my pie chart to show only data from April if I change my slicer selection to 1-4.
I have not found any way to do this, it looks like you cannot create a visual filter or create a filtered table based on a slicer selection.

Thank you very much for your help.

[Anonymous]

Hi @vk_pbi ,

Thank you for your help, I have a calendar lookup table like this which I join to my data table which has a "Start of Month" column as well.

I tried using a measure : 

Max Month Number = MAX(Calendar_Lookup_month[Month Number])

The measure is indeed equal to the max month in my slicer selection but I can't find a way to filter my Pie Chart based on this measure. For example I can't just add a filter Calendar_Lookup_month[Month Number] = Max Month Number.

[vk_pbi]

Hi @Anonymous 

It will be difficult to suggest without knowing your data model

I assumed that, you have custom dates table, create a month number column (MONTH([Date]) in your date table, if its not there, then adjust your measure to match the slicer value with your month number

I hope this will fix your issues