Visual within KPI card -Filtering issue between visual and date slicer

Hi MD_BI_HUI ,

I assume that you calendar table as a retionship with the fact table, and that is the table you are using for your slicer..

If that is the case using the ALL or REMOVEFILTERS will not give you the interactions you want because you will have the context bing passed in the slice but also in the line chart.

For this type of interactions that you want to have a different time period than the one selected, in this case you select one month and get several months after, you need to have a disconnected table to use has your slicer and then do a mesaure similar to this:

Measure with filter = 
CALCULATE(
        [Actuals],
        Calendar[Date] >= MIN(CalendarFilter[Date])
        &&  Calendar[Date] >= MAX(CalendarFilter[Date]) + 365
     )

This is just an example in this case you get the values between the first of the select month and the next year month. You can then play around, and if you have a column ID with values for each month value with a index type value 1,2,3,4,5,...,N then you can make it even easier to move back or forward because you can just add or subctrat the number of months from that index.

Hi MD_BI_HUI ,

I assume that you calendar table as a retionship with the fact table, and that is the table you are using for your slicer..

If that is the case using the ALL or REMOVEFILTERS will not give you the interactions you want because you will have the context bing passed in the slice but also in the line chart.

For this type of interactions that you want to have a different time period than the one selected, in this case you select one month and get several months after, you need to have a disconnected table to use has your slicer and then do a mesaure similar to this:

Measure with filter = 
CALCULATE(
        [Actuals],
        Calendar[Date] >= MIN(CalendarFilter[Date])
        &&  Calendar[Date] >= MAX(CalendarFilter[Date]) + 365
     )

This is just an example in this case you get the values between the first of the select month and the next year month. You can then play around, and if you have a column ID with values for each month value with a index type value 1,2,3,4,5,...,N then you can make it even easier to move back or forward because you can just add or subctrat the number of months from that index.