Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slicers Not Working Correctly

I have a simple model. Sales and calendar tables. The calendar table was created using calendar auto and marked as the date table. Whenver I select a specific row in the table for the year 2021, the year slicer still shows every week for the year. data does not exist for them yet. I tried a single and bi-directional relationship. Is this a bug?

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      These changes make no difference.

    • Anonymous's avatar
      Anonymous
      Not applicable

      That video seems to be showing somethig that has been a default behaviour, when you select the year, you should only be able to select week 5 because no other weeks exist from a data perspective.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous please share the details of the relationship you have between the sales and calendar tables (i.e. what are the key fields being related?)

    • Anonymous's avatar
      Anonymous
      Not applicable

      they are linked by date fields. The date in calendar and the transdate in sales.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Ok Anonymous, you're going to have to provide a little more information if we're going to be able to figure this out...

        What is meant by "the year slicer still shows every week for the year"?  Can you provide a screenshot unexpected results you're seeing?

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion

    Try using "Power Slicer" from Marketplace if you can, and put measure as a filter in it. 

     

    This will filter out Slicer selection upon any selection made on other visuals.

     

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example? 

    Can you share some sample data and the expected result to have a clear understanding of your question?

     

    Best Regards,

    Yuna