Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Kumail's avatar
    Kumail
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KumailThanks, it works today.

Now i see the current month for june, but is it also possible to see both "current month" and "june"?

  • Kumail's avatar
    Kumail
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Anonymous 

     

    Please consider Accept it as the solution to help the other members find it more quickly and consider like if it helped you!!

     

    Regards

    Kumail Raza

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Kumailit works but I had another question in my previous reply.

      If you can answer this one, I can accept this.

       

      Question: Now i see the current month for june, but is it also possible to see both "current month" and "june"?

      • Kumail's avatar
        Kumail
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        Anonymous 

         

        If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.

         

        Regards
        Kumail Raza