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!!
     
     
Anonymous's avatar
Anonymous
Not applicable
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!!