Forum Discussion

anithaMallam's avatar
anithaMallam
Helper III
5 years ago
Solved

need help

Hi All,

          Need your help i have 2 slicers one for year and one for month as shown in the below screenshot.

when i select year 2021 the month slicer has to show only till June and for other years selections it  has to show all months.Could someone please let me know how to get this.

 

Regards

Anitha.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi anithaMallam ,

     

    You need to create a seperate year table. In the example I used DAX to create a chronology.

    Table 2 = DISTINCT('Table'[Date].[Year])

     

    Then create the following measure

    Measure = var _year=SELECTEDVALUE('Table 2'[Year])
return IF(YEAR(MAX('Table'[Date]))=_year,IF(_year=YEAR(TODAY())&&MAX('Table'[Date])>TODAY(),0,1),0)

     

    Best Regards,

    Stephen Tao

     

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    anithaMallam , Create a flag in your date table and use this as visual level filter in the month slicer

     

    new column

    flag = if([Date] <=today(),1,0)

     

    filter flag =1

    • anithaMallam's avatar
      anithaMallam
      Helper III
      5 years ago

      Hi Amit,

                    Thanks you for helping me.as per your suggestion i created a new column with flag and applied month slicer visual level filter on the flag as shown

      Still when i select 2021 it is not filtering to june,its showing all the months.

       

      Regards

      Anitha

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi anithaMallam ,

     

    You need to create a seperate year table. In the example I used DAX to create a chronology.

    Table 2 = DISTINCT('Table'[Date].[Year])

     

    Then create the following measure

    Measure = var _year=SELECTEDVALUE('Table 2'[Year])
return IF(YEAR(MAX('Table'[Date]))=_year,IF(_year=YEAR(TODAY())&&MAX('Table'[Date])>TODAY(),0,1),0)

     

    Best Regards,

    Stephen Tao

     

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