Forum Discussion
sarikei
3 years agoHelper I
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...
sarikei
3 years agoHelper I
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
3 years agoHelper I
Hi,
Anyone can help please? Thanks.