Need dynamic title to not show filter selection when ALL is selected

[magnifybi]

Hey,

I have a dynamic dilter DAX formula that is giving me almost everything I need, however, at the moment it's showing "All" with the slicer name when all is selected.

What I want, is when all is selected, not only does it not display "All" but it doesn't show the slicer name that I have put in.

Selected Top 20 Products = "Top 20 Products - Category : "&SELECTEDVALUE(ProductCategoryCode[ProductCategory], "All")&" - SubCategory : "&SELECTEDVALUE(ProductCategoryCode[ProductSubCategory], "All")&" - Product : "&SELECTEDVALUE('Product'[ProductDescription], "All")&" - Week End Date : "&MIN(vw_DateDim[Week End Date])&" - "&MAX(vw_DateDim[Week End Date])

[magnifybi · Accepted solution]

Solve it myself;

Selected Top 20 Products = "Top 20 Products "&IF(HASONEVALUE('ProductCategoryCode'[ProductCategory])," - Category : "&SELECTEDVALUE(ProductCategoryCode[ProductCategory], "All"),"")&IF(HASONEVALUE(ProductCategoryCode[ProductSubCategory])," - SubCategory : "&SELECTEDVALUE(ProductCategoryCode[ProductSubCategory], "All"),"")&IF(HASONEVALUE('Product'[ProductDescription])," - Product : "&SELECTEDVALUE('Product'[ProductDescription], "All"),"")&" - Week End Date : "&FORMAT(MIN(vw_DateDim[Week End Date]),"DD-MM-YYYY")&" - "&FORMAT(MAX(vw_DateDim[Week End Date]),"DD-MM-YYYY")