Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago

Selection from Slicer

Hi,   I have a Slicer defined in my report, it displays a list of predefine Date. i.e. This Month, Last Month, This Year, Last Year. I want to create the Measure to check if the selected value is...
Need Help
  • sarikei's avatar
    sarikei
    Helper I
    3 years ago

    Thanks JorgePinho, Yes, I got it work as following!

     

    MySelection  = IF(

        SELECTEDVALUE(DateTable[Date Selection]) = "This month",

        "Yes","No"

    )

     

     

    Now, instead of “Yes”, if the selection is “This month”, I actually want to read the “From – To” date value from the other Slicer. And then group them together. Then I will use this measure in the other visual (bar chart). I know how to read the “From – To” value using:

     

    MIN(DateTable[Date Selection])

    MAX(DateTable[Date Selection])

     

    But how can group all the value from this??

     

    Many thanks.

     

    • sarikei's avatar
      sarikei
      Helper I
      3 years ago

      Hi,

       

      Anyone can help please? Thanks.

    • MAwwad's avatar
      MAwwad
      Solution Sage
      3 years ago

      Please provide an example to better understand your requirement.

      • sarikei's avatar
        sarikei
        Helper I
        3 years ago

        Hi,

         

        So I want to read the "From - To" date from the Slicer into the new measure.

        Then I want use this Measure in another Visual, so the data selection in this Visual will be based on this Measure (which is From - To from the Slicer).

         

        How to do this please? Thank you.