Visuals based on filter

[unnijoy]

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 selected. Visuals should show the numbers if only one country is         selected.

2) We can see that if data is not available the visuals will show (Blank). Can we make it "-" or any mesage like "Data not available".

[amitchandak]

Try a measure like this

new Measure=

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

[harshnathani]

Hi @unnijoy ,

Please find .pbix attached.

Hope this is what you require.

https://drive.google.com/file/d/1lZTc-acls1PKWWpqQ2OWYp2KcQm-wqkD/view?usp=sharing

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[harshnathani · Accepted solution]

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

Hi @unnijoy ,

1. I think you can change your slicer to single-selection only mode to solve the problem:

2. Assuming you have a measure to calculate the attrition % called "attrition %" in your report.

You can try to add a new measure like:

if(isblank(attrition %),"-",attrition %)

Please try.

Aiolos Zhao