Forum Discussion

jmkvalsund's avatar
jmkvalsund
Helper III
4 years ago
Solved

Can I select a bookmark based on current month when loading report?

I have a slicer showing month of year. I have not found a way to set the slicer to current month when the report opens, so I have to change that manually month by month. Small job, but it has to be d...
Need Help
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, jmkvalsund 

     

    You can try the following to set the slicer to the current month.

    Column:

    Monthnum = MONTH([Date])

    Measure:

    Measure = IF(SELECTEDVALUE('Table'[Monthnum])=MONTH(TODAY()),1,0)

    Place Measure in the slicer's view filter and set it to equal 1.

         

    The slicer then displays only the current month's options. Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

truptis's avatar
truptis
Community Champion
4 years ago

Hi jmkvalsund , Please try this:
Step 1-> Transform data -> (in power query editor) click on Add column->Custom Column (Current Month)

put this DAX:
Date.MonthName( DateTime.LocalNow() )

Click on OK -> Apply & Close changes 

 

Step 2:

In the report view, put the slicer and use current month(that we made in step 1) as date field.

Step 3: Select the slicer -> Go to Format pane-> Selection control -> turn ON the Single Select option

This will default your slicer to be at current month.

jmkvalsund -> Please mark this as a solution & hit the thumbs up if it helps you. Thank you. 

 

Regards,

TruptiS