Forum Discussion

ravitejaballa's avatar
ravitejaballa
Helper III
6 years ago

Slicer With single selection

Hi, I have a data like below, where "Months Since Started" is months difference with current date => (TodayMonth - startDateMonth) Now i want to have slicer on report which filters 1. Contract ex...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

 

  • ravitejaballa's avatar
    ravitejaballa
    Helper III
    6 years ago

    dax Ashish_Mathur amitchandak 

    Here is my sample data.

     

    DeviceContract Start DateMonths Since Started
    A17-Dec-193
    B21-Sep-1818
    C15-Oct-195
    D14-Jan-202
    E16-Sep-196

     

    IndexContract expirying
    1with in 6 months
    2with in 3 months
    3with in 1 month
     

     

    So Slicer should filter table as below.

    1. Contract expirying "with in 6 months" => Shows Devices = A, C, D, E

    2. Contract expirying "with in 3 months" => Shows Devices = A, D

    3. Contract expirying "with in 1 month" => Shows Devices = C, E

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      That is exactly what my solution does.  I have shared the file with you.

      • ravitejaballa's avatar
        ravitejaballa
        Helper III
        6 years ago

        Ashish_Mathur No, It is not working.

        If you select "within 1 month" no data is shown.

    • dax's avatar
      dax
      Community Support
      6 years ago

      Hi ravitejaballa , 

      Yes, as Ashish_Mathur  mentioned , the"within 1 month" option should return blank(the date which within a month of today is 202/2/29-2020/3/31, no records within this range, it should return blank). Or you also could inform me your logic of  "within 1 month", then we will help you more correctly.

      Best Regards,
      Zoe Zhi

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • ravitejaballa's avatar
        ravitejaballa
        Helper III
        6 years ago

        Ashish_Mathur dax 

        To simplify further.

        Same slicer but data should filter as shown.

         

        ExpiryIn1Month =
        IF(mtagData[contractDateDiff.months] == 6, TRUE())

         

        ExpiryIn3Months =
        IF(AND(mtagData[contractDateDiff.months] >= 1, mtagData[contractDateDiff.months] <= 3), TRUE())

         

        ExpiryIn6Months =
        IF(AND(mtagData[contractDateDiff.months] >= 1, mtagData[contractDateDiff.months] <= 6), TRUE())