Want to select current month as default month in the slicer

[shilpa123]

Hi

Actually my requirement is like in the report and in the slicer by default current  month has to be selected dynamically without using any naming conventions like current year it should be in the same format like jan month and it should be selected dynamically. Can any one help me with this please.

[RP_PBUSER · Accepted solution]

We can achieve this requirement by using a workaround. We can create a column which can have same value but get updated in the background based on current Month.

Current Month=If(year(column)=year(now())&&month(date)=month(now()),"Current month",Month(date))

You can use this DAX to create a column value "Current Month" and gets updated whenever the month change no need to do any external work.But there is no possibility to get current month name directly to the value and make it selected by default as the month names changes every month

you can refer this https://community.powerbi.com/t5/Desktop/Selecting-the-current-month-year-as-a-default-selection-in/...