Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Hello,
Thank you for your answer!
I tried and unfortunatly it did'nt work...
Maybe I have done wrong...
Thank you!
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 😀
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |