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.

 

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.