Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date slicer is not changing date when selecting other slicer

Hello all,   We're trying to desing a dashboard in which we have 2 slicers:   1) Date slicer with between option     2) Mosaic slicer in which I can select the Department.   The thing ...
"Date"
"Slicer"
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hello all,

     

    Just for your information the solution applied was:

     

    1) Created required slicers
    2) Go to Format

    3) Selecting Department, enable filter bottom of Date Slicer

    Neither any additional tables.

     

    I've checked using bi-directional relationship and it worked. But then i've tried removing this bi-directional relationship and it worked also. I don't know if it worked without bi-directional relationship, but maybe data as it's cached and if data is updated it'll fail.

     

    Anyway, the general solution is proposed one and with bi-directional relationship.

     

    Thanks a lot to everyone for feedback

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

That is a question for your data model, your selected fields, and then search/filter direction.

 

BTW, your desired behavior is considered sub-optimal for Power BI performance.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello lbendlin,

    The thing is that i want that when I select a department, the date on slicer change also without any interaction on this slicer.


    I don't understand the reason of this commented sub-optimal performance due to it's that happens in others date slicers. Do you know if this requeriment is possible?

     

    Best Regards

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      It is possible but potentially undesirable. 

       

      Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
      https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
      Please show the expected outcome based on the sample data you provided.

      https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello,

         

        The data is example data just to test it. Anyway you can use this test data to check it.

         

        01/01/2022;IT;30
        02/01/2022;Marketing;45
        03/01/2022;CEO;42
        04/01/2022;Big Data;39
        05/01/2022;IT;31
        06/01/2022;Marketing;36
        07/01/2022;CEO;30
        08/01/2022;Big Data;38
        09/01/2022;IT;26
        10/01/2022;Marketing;50
        11/01/2022;CEO;30
        12/01/2022;Big Data;41
        13/01/2022;IT;28
        14/01/2022;Marketing;47
        15/01/2022;CEO;28
        16/01/2022;Big Data;49
        17/01/2022;IT;34
        18/01/2022;Marketing;31
        19/01/2022;CEO;49

         

        For example if I select CEO in a slicer I want that date in the slicer with Between option be changed from first date that CEO appears on the dataset (03-january-2022) until last date that CEO appears (19-January-2022).

         

        Thanks a lot for your feedback and if you need any other additional information from my end please do not hesitate to request it to me.