Forum Discussion

jmkvalsund's avatar
jmkvalsund
Icon for Helper III rankHelper 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.

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
4 years ago

HI jmkvalsund 

Please create serial for your month in DAX

 

Select the Month Name or Month No Col and go to Sort By option, and select SERIAL  sort

 

In Drop Down slicer, select Sort by MONTHNAME 

 

SO YOUR SLICER ALWAYS SHOWS, CURRENT MONTH FIRST. GO TO SLICER SETTING AND SELECT OPTION, SINGLE SELECT, SO YOUR CURRENT MONTH IS SELECTED BY DEFAULT.

If not solved, Please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos