Forum Discussion

anithaMallam's avatar
anithaMallam
Icon for Helper III rankHelper 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 ...
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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper 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