Forum Discussion
Default setting by opening report
Hi, We have a report with a few slicers (3) that can be changed. One of the slicers is a date slicer to choose between the months. Now when you save and publish it to the service, by opening you...
Hello Anonymous
You can do something like this
Default Month Slicer = IF ( MONTH ( NOW () ) = MONTH ( Dates[Date] ) && YEAR ( NOW () ) = YEAR ( Dates[Date] ), "Current Month", Dates[Year-Month] )If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and I would love to see your like Or
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick implemented solution.
Regards
Kumail Raza
Kumail
Impactful Individual
Impactful IndividualHello Anonymous
You can do something like this
Default Month Slicer =
IF (
MONTH ( NOW () ) = MONTH ( Dates[Date] )
&& YEAR ( NOW () ) = YEAR ( Dates[Date] ),
"Current Month",
Dates[Year-Month]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and I would love to see your like Or
If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick implemented solution.
Regards
Kumail Raza