Forum Discussion

dsinha's avatar
dsinha
Frequent Visitor
8 years ago

Selecting the current month/year as a default selection in chiclet slicers when the report opens up

  Hi,   I have a requirement where the latest month and year in the chiclet slicer should always be selected when the report opens up. Currently I have set the property of the slicers as forced s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

dsinha,

A workaround that I can think of is to create the following column in your table, drag the column to Page Level filter and set its value to 1.

checkdate = IF('Table'[Year]=YEAR(TODAY()) && 'Table'[Month]=MONTH(TODAY()),1,0)


Regards,
Lydia

dsinha's avatar
dsinha
Frequent Visitor
8 years ago

Thanks for your reply Lydia.

But with the solution which you have provided ,we can only see one year/month in the filter which is the latest one.

But my requirement is only to select the latest year/month by default along with other years/months being displayed in the chiclet slicer.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dsinha，

    According to my knowledge, it is not possible to automatically show current year/month as you describe.

    Regards,
    Lydia