Default selected value in a slicer

[AnumZehra]

I have a slicer which show all 12 months. How can i set the default selected value in that slicer as of current month. It means whenever the dashboard is refreshed , it should show current month as selected value in the slicer. Kindly help.

Thank You

[ChandeepChhabra]

@AnumZehra ,

I don't think you can do that in a slicer but you can have a measure to display the current month on the Dashboard and also filter the other measures for the current (active) month

Try a measure like this

Current Month = MONTH(TODAY())

and let's say you have Total Sales measure linked to your Date Table

Total Sales =
CALCULATE ( [TOTAL SALES], FILTER ( Date, Date[Month] = [Current Month] ) )

You can now use a card visual for Current Month Slicer and use the Total Sales Measure for any of your visuals.

Hope it helps

Thanks

[AnumZehra]

Thank you ChandeepChhabra for your response. Actually in my case, the user wants to see the sales made in previous months / current month too so, if I make the measure like this

Total Sales =
CALCULATE ( [TOTAL SALES], FILTER ( Date, Date[Month] = [Current Month] ) )

I am hard coding it for only the current month. My requirement is, at first when the page refreshes , the calculations should be as of current month, later if user needs to see previous months sales, he can select another month from the slicer.

[ChandeepChhabra]

@AnumZehra I can take shot at trying it

Can you share some data?