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

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

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

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