Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Time Slicers Output

Hello,

 

I have two slicers and a simple question.

 

 

 

 

 

How can i create a mesure to capture what is in my slicer selection for each slicers ?

May i could also modify a slicer to say 31/12/2020 23:59:59 instead 00:00:00 ?

 

Regards !

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous whatever column is used in the slicer, use MIN and MAX function to get the start date and end date.

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      In fact i would like the exact output for actual slicer selection not all his values:

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous Not sure what you mean:

     

    Selected Value first Slicer =
MAX ( FirstSlicer[Date] )

Selected Value 2nd Slicer =
MIN ( SecondSlicer[Date] )

     

    Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡