From Jan to October Month only have to show in slicer for 2021 Year

[NavaneethaRaju]

Hi , 

I using two slicer, one for year and another one for month, if i select 2021 year, the month slicer only have to show upto october month, because 2021 November and december values(Sales) not added. Kindly advice how to create a slicer while select 2021 year and month upto october.

[v-yingjl · Accepted solution]

Hi @NavaneethaRaju ,

You can create a measure like this, put it in the month visual filter and set its value as 1:

A = 
IF (
    SELECTEDVALUE ( 'Table'[Date].[Year] ) = YEAR ( TODAY () ),
    IF ( MAX ( 'Table'[Date].[MonthNo] ) <= MONTH ( TODAY () ), 1, 0 ),
    1
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NavaneethaRaju]

Hi, @v-yingjl ,

I'm getting error, using now.

And one thing in your measure You used the column [monthNo], that is not in your table. please check and advice.

Your Measure.

Your table.

[Sai4237]

Create the following Measure :

Slicer_filter =

INT (

NOT ISEMPTY ("Sales Table" )

)

Use this Measure on the Month Slicer and put it on Visual level Filter and set it to 1.

This gives only those months have sales in your Sales Table.

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

Appreciate your Kudos!!

[VahidDM]

Hi @NavaneethaRaju 

Create a measure with this code:

Measure = if(max('Date'[Date])<=today()+30,1,blank())

Then add that to the filter pane to filter your month slicer and set it to is not blank.

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

Appreciate your Kudos!!