topic Need dynamic title to not show filter selection when ALL is selected in DAX Commands and Tips

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

magnifybi — Tue, 09 Jun 2020 11:00:31 GMT

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

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

magnifybi — Tue, 09 Jun 2020 13:48:31 GMT

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")