Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
6 years ago
Solved

Visuals based on filter

I have attriton data based on country. I have visuals whcih shows attrition %. I have a dropdown filter based on country.   1) Now i need all the visuals to be blank if multiple countries are selec...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    unnijoy ,

     

    For the entire visual to be blank.

    You can use the following measure.

     

    Category1 =
    var __selval = HASONEVALUE('TABLE'[Country])

    return
    //__selval
    //IF(__selval,1,0)
    IF (__selval,
    SWITCH(
    TRUE(),
    [Attr%S] < [25PercentileNew] , "Top Quartile",
    ([Attr%S] >= [25PercentileNew]) && ([Attr%S] < [50PercentileNew]) , "25th to 50th Quartile",
    ([Attr%S] >= [50PercentileNew]) && ([Attr%S] < [75PercentileNew]) , "50th to 75th Quartile",
    "Bottom Quartile"
    )
    ,
    BLANK()
    )
     
     
     
     
     
    Regards,
    Harsh Nathani
     
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
     
     
amitchandak's avatar
amitchandak
Super User
6 years ago

Try a measure like this

new Measure=

if(isfiltered(country[country]) && countx(allselected(country),country[country])=1,[measure],blank())