Forum Discussion

Silvie's avatar
Silvie
Icon for Helper I rankHelper I
2 years ago
Solved

Only blank values in slicer

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 'Perio...
Tips and Tricks
  • Nithinr's avatar
    Nithinr
    2 years ago

    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

     

     

     

Nithinr's avatar
Nithinr
Icon for Resolver III rankResolver III
2 years ago

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's avatar
Silvie
Icon for Helper I rankHelper I
2 years ago

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)?