Filter Slicer Based on Setup/Filters in a Line Chart

[asjones]

I have a line chart in Power BI that has the X by Fiscal Year.  I also have a filter on the chart limiting the range of the fiscal years (I have more years than needed for the chart).  On the same page is a slicer that shows Country (related table). There are countries listed in the slicer that are not in the table range. I tried using the examples of using DAX to hide slicer data that does not have a value and it hid a few things. However some of the Countries have data listed outside the date range in the line chart. So the slicer still shows them. This is making the country list slicer much larger than it should be.

Is there a way to filter the slicer based on the filters set in another visual? 

I also tried setting the fiscal year limits in the DAX slicer code, however the code for that did not seem to work (other tables for fiscal year etc…) In some ways this seemed like  the best idea. If I worked right I could apply the DAX Slicer filter to both the Slicer and the line chart (maybe??)

Thoughts and ideas?

Thanks

Alan

I had started with examples from here

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

[MFelix]

Hi @asjones .

Wihtou any data is difficult to give the exact answer but in this case you need to use a crossfilter function to get a measure that filters out the values you don't need, of course this depends on the data model you have.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.