Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Slicer Between has "wrong" values

Hello all

 

I have a maintable (Table1) and a orders Table (Orders).

Orders got a column OrderDate. I added a slicer for these dates (between mode)

 

Table1 and Orders are in a relationship. Cross-filtered in both directions.

Table1 has a column Year.

 

My problem is, that the between slicer shows the first date found in the data, altough i filtered only for 2019 in Table1.

 

Is there something im missing or is this kinda slicer not supporting a dynamic change in first/last date?

 

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Sounds very strange if the setup is as you say. Did you Edit Iteractions so that the slicers do not interact? How are the tables related?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Greg_Deckler

       

      I made an example file, see attached.

      (example.pbix)

      I selected Year 2019 so i want the slider min date show 01.01.2016

       

      The current min date 01.01.2014 is for another (not selected) year

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is it in the proper date format, please change it to year.