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. 

[Nithinr · Accepted solution]

@Silvie  I caught the issue. Youhave third slicer orgtype.org causing the issue, What you need to do is to disable the edit interaction between orgtype.org and other slicers. select orgtype.org ---> format--> edit interactions---> disable it for other two slicers . then select desired slicer value

[Silvie]

OMG! It's working like a charm now. Many, many thanks, Nithinr!

[Silvie]

What do you exactly mean with 'sync slicers'? 

[Nithinr]

see if anything enabled under that red tick after selecting slicer, basically sync slicer means if they enabled one page slicer will affect another page.

[Silvie]

There were filters applied for 'Period type' but I removed them. 

This is how it looks like now. Still showing only blank values. 

Should I share my elaborated file through Onedrive (maybe by sharing it only with you through an email address since it contains sensitive data)?

[Silvie]

Many thanks!

I checked the 'Sync slicers' and enabled only the A008 OOP/AG page. Unfortunately this doesn't change anything.

[Nithinr]

yeah you just need to see buttion beside eye button, but yeah I see nothing is checked for it, are you sure no filters applied to slicer ? its little strange 

[Silvie]

No problem at all. I don't see any changes, correct? 

Indeed, I'm also able to see the filters now. When sending you the pbix file I made a duplicate of my more elaborated file and removed the unnecessary queries.

I also checked the data model and for every query / table there is a link with the period dimensions through the field 'Period' and with the organization dimensions through the field key. No other relationships are made. 

Don't understand why I'm not able to see the filters in my more elaborated file. So strange. 

[Nithinr]

Ah may be the issue is with sync slicers check that for those two slicers.

[Silvie]

Did you have to change anything because I can't open the pbix file due to 'sensitivity issues'. 😞

But happy to read that it works. Many thanks! 🙂

[Nithinr]

I am extremely sorry , changed sensitivity

pbix 

[Silvie]

I'm getting 'The file type (.zip) is not supported. 

Does this link work? A008 Out of Pocket.pbix

[Nithinr]

pbix file 

[Nithinr]

I am able to see filters. this is strange. I will sned file I have

[Nithinr]

This works

[Silvie]

Sure, Nithinr. 

The only problem is that I'm getting the error 'The file type (.pbix) is not supported.'

I've uploaded it in my Onedrive: A008 Out of Pocket.pbix

Are you able to download this file? If yes, I will remove the file afterwards. 

[Nithinr]

Its asking for sign in. unable to download. are you able to zip it and send?

[Silvie]

A008 Forecast

OOP en AG

The fiscal years are also present in the three tables. 

Do you have any idea what I'm doing wrong? 

[Silvie]

Hi Nithinr, 

These are (an extract of) the tables with there columns. 

Periode dimensies

OOP en AG

A008 Forecast (no Fiscal Quarter data in here)

KR,

Silvie

[Nithinr]

looks like there are no matching values between dimensions and fact