Open with filters

[Emilie]

Hello,

I set a powerBi report on HR data.

I would like to allow users to position themselves directly on the current month and year when opening the report.

I can't find this feature.

Do you know if it is possible?

Thank you very much!

Emilie

[v-zhangti · Accepted solution]

Hi, @Emilie 

You can check the following methods.

Measure =
IF (
    SELECTEDVALUE ( 'Calendar'[Month] ) = MONTH ( TODAY () )
        && SELECTEDVALUE ( 'Calendar'[Year] ) = YEAR ( TODAY () ),
    1,
    0
)

Drag Measure into your view's Filters and set it to equal 1.

It will be possible to display data only for the current month of the year.

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.

[Emilie]

Hello,

Thank you for your answer!

I tried and unfortunatly it did'nt work...

Maybe I have done wrong...

Thank you!

[jaideepnema]

Hi @Emilie ,
have you tried applying the report level filters  or as a slicers as shown below ?  

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀