Select the Previous months automatically when I select One month

[Pavan_123456789]

@Ahmedx @parry2k @Greg_Deckler @ryan_mayu @Ritaf1983 @amitchandak @HotChilli @jmpuigdollers2 @vicky_ @Vicky_Song @Jihwan_Kim @miTutorials  @DataInsights 

Here when i select 4 month automatically in the slicer should need to select the previous months also 1,2,3 also  

[parry2k]

@Pavan_123456789 you need to create another table that will be used for the slicer, and it will be a disconnected table. And then add the following measure:

In the visual, use month number from your regular table and this measure:

Sales  = 
vAR __SelectedMonth = SELECTEDVALUE ( 'Slicer Table'[Month Number], MONTH ( TODAY () ) ) 
RETURN
CALCULATE (
    SUM ( 'Table'[Sales] ),
    KEEPFILTERS (
       'Calendar'[Month Number] <= __SelectedMonth

    )
)

[Pavan_123456789]

Hi @WinterMist 
Thank you for your replay is there any alternative by without using the between slicer (The client need only this slicer format )

[WinterMist · Accepted solution]

@Pavan_123456789 

Have you considered the slicer Style "Between".

"Between" already does this by nature.

Regards,

Nathan