Forum Discussion

Emilie's avatar
Emilie
New Member
4 years ago
Solved

Open with filters

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

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

3 Replies

  • jaideepnema's avatar
    jaideepnema
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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 ğŸ˜€

  • Emilie's avatar
    Emilie
    New Member
    4 years ago

    Hello,

     

    Thank you for your answer!

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

     

    Maybe I have done wrong...

     

    Thank you!

     

     

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    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.