Excel Slicer Not Able to Filter a Chart

[anilkumarpoda]

I have created a dashboard on Excel and used a Year slicer to dynamically change charts. But 1st chart in my dashboard is not changing as per the slicer. I have created a Date Table in Excel data modeling and mapped date column from date table to various date columns in other tables.

The problem is with slicing data in 1st Sheet, Scheme_Details. Can anyone check my sheets, data model and relationships and find out why slicer is not getting applied on 1st chart that uses data from Scheme_Details sheet?

Download Excel file using below link

Dashboard 

[anilkumarpoda · Accepted solution]

Fixed the issue by using DAX measures in Excel charts instead of using direct columns. With the help of USERELATIONSHIP function used inactive relationships. Then used CUBEVALUE funtion to use measures as KPIs. 

[andhiii079845]

Why you post it in Power BI Desktop? You want help in Excel, right? 

[anilkumarpoda]

Yes you are right, but it's related to data modeling in Excel. There is no dedicated Excel forum on this community. That's why posted here.