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

     

     

     

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

What do you exactly mean with 'sync slicers'? 

 

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

    Many thanks!

     

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

     

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

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