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

[MD_BI_HUI]

Hi 

im strugging with a line chart visual showing Actuals, Last year and RF(forecast) as lines with Markers for Current month and last month as FY (full year) where RF shall be dashed line starting from next month to till end of the year.
The measures comes directly from SSAS.
The problem comes with filtering from slicer (date -> year and month hierarchy) user want to select "current month "-> so it may vary from past month to even the following (as some of actuals are already in for 2 months in advance:/ ) 

I need to show entire year in X axis for RF and LY - > this measures shall not react to Date slicer, but Actual should

ive tried with interactions between date slicer and visual but then dax  Actual measure cant "catch" selected Months

on the other hand neither removefilters nor all dax functions works for RF and LY if Interactions are on and these measures shows data only till selected months on the slicer 
Do you have any idea how to build such measures ?

[MFelix · Accepted solution]

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.

[v-venuppu]

Hi @MD_BI_HUI ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @MD_BI_HUI ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @MD_BI_HUI ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MFelix for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[MFelix · Accepted solution]

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.

[MFelix · Accepted solution]

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.