Only blank values in slicer

[Silvie]

Hi, 

I made line chart combining 2 queries 'OOP en AG' (showing actuals data) and 'A008 Forecast' (showing forecast data). 

The relationships are made in the data model between the 'Key' and 'Period' fields. 

Now I want to add a slicer with 'Period Type' (="Period Desc" in the other tables) and 'Filter year' (="Fiscal Year" in the other tables but it only shows blank values even though a relationship was made between the tables. 

There are no empty values in my data. 

A008 Forecast

OOP en AG

Do you know what I should do to show me any values in the slicers? Period Type should be a dropdown list of: Fiscal Period, Fiscal Quarter and Fiscal Year. Filter Year should show me values: 2018-19, 2019-20, 2020-21, ...

I would like to have my line chart based on fiscal year numbers. (Now it's showing me fiscal period, fiscal quarter and fiscal month data on the X-axis.)

Many thanks in advance for your help. 

Silvie

P.S.: I checked other posts, but couldn't find my answer. 

[Silvie]

There actually are matching values between the dimensions and facts. I only posted an extract of the data in the columns. 

Dimensions table

A008 Forecast

[Nithinr]

is it possible for you to share pbix file

[Nithinr]

There may be mismatch of data in 'Period Name' which is there in OOP/AOO8 and "period"  in period Dimensions, can you also post how that columns looks in period dimension table