Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Slicer Selected Values Label to text

Hi everyone, im trying to replicate the summary of selections on my dropdown slicer, which currently holds three fields: FY, FQ and M. So depending on the values I am selecting the slicer shows a su...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    use ISFILTERED, HASONEFILTER, FILTERS and VALUES to figure out if the columns are filtered. Then concatenate the results accordingly.

     

    Note that there is a difference between "nothing filtered yet"  and "nothing filtered as result of the filters being cleared". You could call that a bug, or a feature.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Many thanks, I was using the method below but I was sure there is probably a better way to do it. I will follow your recommendations.

     

    dateLabel = 
Var year_ = SELECTEDVALUE(cm[ReportFY],BLANK())
Var quarter_ = SELECTEDVALUE(cm[ReportQ],BLANK())
Var month_ = SELECTEDVALUE(cm[monthLabelShort],BLANK())

return
 SWITCH(
    TRUE(),
        quarter_="","Selected Date: " & CONCATENATE(year_," (FY) "),
        month_="","Selected Date: " & CONCATENATE(CONCATENATE(year_," (FY) + "),CONCATENATE(quarter_," (FQ)")),
        "Selected Date: " & CONCATENATE(CONCATENATE(CONCATENATE(year_," (FY) + "),CONCATENATE(quarter_," (FQ) + ")),CONCATENATE(month_," (M)")
    ))
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

use ISFILTERED, HASONEFILTER, FILTERS and VALUES to figure out if the columns are filtered. Then concatenate the results accordingly.

 

Note that there is a difference between "nothing filtered yet"  and "nothing filtered as result of the filters being cleared". You could call that a bug, or a feature.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Many thanks, I was using the method below but I was sure there is probably a better way to do it. I will follow your recommendations.

     

    dateLabel = 
Var year_ = SELECTEDVALUE(cm[ReportFY],BLANK())
Var quarter_ = SELECTEDVALUE(cm[ReportQ],BLANK())
Var month_ = SELECTEDVALUE(cm[monthLabelShort],BLANK())

return
 SWITCH(
    TRUE(),
        quarter_="","Selected Date: " & CONCATENATE(year_," (FY) "),
        month_="","Selected Date: " & CONCATENATE(CONCATENATE(year_," (FY) + "),CONCATENATE(quarter_," (FQ)")),
        "Selected Date: " & CONCATENATE(CONCATENATE(CONCATENATE(year_," (FY) + "),CONCATENATE(quarter_," (FQ) + ")),CONCATENATE(month_," (M)")
    ))