Forum Discussion

vimina's avatar
vimina
Frequent Visitor
3 years ago
Solved

Display Text based on date slicer selection

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 a...
Need Help
  • vimina's avatar
    vimina
    3 years ago

    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")
vimina's avatar
vimina
Frequent Visitor
3 years ago

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")