Display Text based on date slicer selection

[vimina]

I have two slicers : Year and Period. Year is a single selector slicer and Period is multiselector. A Text needs to be displayed in a card based on the slicer selection.
If an year is selected and all the period of that year are selcted then display "Selected Year is '2022' " ELSE
if any period is selected for eg 1, 3,5 then display "Selected Range is for "Year" and Period 1,3,5"

pbix file: https://drive.google.com/file/d/1owzvBBV1ALzdNukg5pgjUaPApTgYDPaD/view?usp=sharing

[vimina · Accepted solution]

I have tweaked the below measure, if anybody is looking for the similar requirement then this measure can be used:

Modified Card Value =

IF(ISFILTERED('Date'[Year]) && ISFILTERED('Date'[Period]),

    "Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0") & " And " &

    IF(DISTINCTCOUNT('Date'[Period]) = 1,

        "Selected Range is for Period: " & MIN('Date'[Period]),

        IF(MAX('Date'[Period]) - MIN('Date'[Period]) + 1 = DISTINCTCOUNT('Date'[Period]),

            "Selected Range is for Period: " & MIN('Date'[Period]) & " - " & MAX('Date'[Period]),

            "Selected Range is for Periods: " & CONCATENATEX(VALUES('Date'[Period]), 'Date'[Period], ", "))),

    "Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0")

[Ahmedx]

pls try this

Card_Value = 
IF( ISFILTERED('Date'[Year])&&ISFILTERED('Date'[Period]),
        "Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0") &" And  "&"Selected Range is for Period: " & MIN('Date'[Period]) & " - " & MAX('Date'[Period]),
        "Selected Year is : " & FORMAT(SELECTEDVALUE('Date'[Year]), "0")
)