Forum Discussion

Minakshi's avatar
Minakshi
Resolver I
6 years ago
Solved

table relations

Hi all,

I have one base table and other is reference table of its. I want to use mutliple slicer with this. I created a relation ship between them and all the slicer works other than Date.

 

Kindly help me with this. How to make date slicer working along with other slicers.  table relationship for your reference.

 

Thanks in advance

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Minakshi 

    Please try the following:


    1. Create a another calendar table with Calendar(), enter the earliest date from the 2 table as start date, and use latest date from the 2 tables as end date.

     

    Calendar table = Calendar(Date(),Date())

     

    2. Relation both tables to the calendar table using [Date] column, you should have a many to one relationship, where both tables on the many side, and the calendar table on the one side.

     

    3. Then, use the Date column in the new calendar table as slicer to filter visuals.


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

7 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Minakshi ,

     

    From which table are you using the DATE slicer?

    Based on your relationhip set-up, all the slicers sould come from Planogram Compliance table as the filter direction is set from this table to other table.

     

    Thanks,

    Pragati

    • Minakshi's avatar
      Minakshi
      Resolver I
      6 years ago

      Pragati11 yes, you are absolutely right. All the slicers are from planogram compliance table. But date and month are not filtering the data while others are doing perfect job.

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Minakshi ,

         

        This is should ideally work.

        Can you share some screenshots on that it's not filtering with DAte filter? 

        Also screenshot of your sample data?

         

        what is data-type of DATE column in both of your tables?

         

        Thanks,

        Pragati