Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😀
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |