Slicer in Slicer page should not affect a chart on another page

[andicornejo12]

Hello Community,

I am building a report in which I want the user to first set all the slicers needed on the report front page:

As you can see, I have set a slicer for April 2023. However, I have a page report that contains a bar graph by month and I would like this graph  to show me not only the April column but all months from January to April while the Card visuals show me only that particular month. Is there a way to do this?

I have tried with Edit Interactions, but this seems to work only with slicers and graphs on the same page of the report. I have also tried to use YTD measures witht he REMOVEFILTERS instead but is not working either.

Thanks so much in advance for your help, I am struggling to find a solution.

[Anonymous]

Thanks for the reply from ahadkarimi , please allow me to provide another insight:

Hi, @ahadkarimi 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.Then I created a calculated table like this as a slicer, and it remains unrelated to the original table:

date11 = VALUES('2020-2024'[Date])

3. Below are the measure I've created for your needs:

Total Revenue YTD = 
VAR select1 =
    MAX ( 'date11'[Date] )
RETURN
    CALCULATE (
        SUM ( '2020-2024'[Revenue] ),
        FILTER ( '2020-2024', '2020-2024'[Date]<= select1&&YEAR('2020-2024'[Date])=YEAR(select1 ))
    )

4.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andicornejo12]

hi @Anonymous this is exactly the solution I need. However even after recreating the steps doesnt seems I am getting this result like in your attached pbix

[Anonymous]

Hi, @andicornejo12 

Thanks for the quick reply.

It is recommended that you check whether your table relationship affects your measure, there is no relationship between my calculated table and the original table, and the slicer is from the newly created calculated table in the step.

Of course, you can also consider sharing PBIX with us and we can help you further.

Take care to remove sensitive data.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ahadkarimi]

Hi @andicornejo12, you can create a Year-to-Date (YTD) measure for the bar graph that removes the slicer filter. give this a try, and if you encounter any issues, let me know.

Total_Actual_YTD = CALCULATE(
    SUM(RevenueTable[RevenueActual]), 
    DATESYTD(DateTable[Date]), 
    REMOVEFILTERS(DateTable[Month])
)

Did I answer your question? If so, please mark my post as the solution! ✔️
Your Kudos are much appreciated! Proud to be a Solution Specialist!

[andicornejo12]

hi @ahadkarimi 

Thank you so much for your reply, unfortunately as I mentioned in my post, I had already tried before with the removefilters function but it didnt help 😞