Forum Discussion

erihsehc's avatar
erihsehc
Icon for Helper III rankHelper III
8 years ago
Solved

YTD slicer issue

hello,   I have a question on YTD slicer. I have created a linking table to link between data model and slicer YTD table. When I select the YTD slicer, the YTD sales does not update, would expert h...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi erihsehc,

     

    I'm modify the 'cross filter direction' option to 'both' at 'manage relationship'. When this option has setting to 'single', the filter effect only works on one side.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI erihsehc,

 

Can you provide the measure formula to test? In addition, you can also try to modify 'cross filter direction' option to 'both' and try again.(manage relationship)

 

Regards,

Xiaoxin Sheng

erihsehc's avatar
erihsehc
Icon for Helper III rankHelper III
8 years ago

hi Anonymous, please find the pbix at the bottom of my top post, thanks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi erihsehc,

     

    Actually, after I modify the 'cross filter direction' option, your formula can change on update the slicer selection.

     

    Regards,

    Xiaoxin Sheng

    • erihsehc's avatar
      erihsehc
      Icon for Helper III rankHelper III
      8 years ago

      thanks Anonymous, it is working, would you explain how it works? I could not see what have been updated on the data model

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi erihsehc,

         

        I'm modify the 'cross filter direction' option to 'both' at 'manage relationship'. When this option has setting to 'single', the filter effect only works on one side.

         

        Regards,

        Xiaoxin Sheng