in Title of the visualisation selected items

[Margreet]

Hello,

Hope someone can help me. I have a slicer of products (for example 10 products)

Now I want in title (fx) of the visualisation see all the selected items from the slicer and when you don't select a product in the slicer than the text "all product".

I tried the measure

Title_Product = "Product : "& if(hasonevalue(‘Product[Productcode]),selectedvalue(' Product[Productcode]), concatenatex('Product,'Product[Productcode],","))

When notihing is selected I got the names of the 10 products... I want then tot see "all products"

Thanks for reaction!

[FreemanZ · Accepted solution]

try this:

Title_Product = 

IF(

    COUNTROWS(VALUES(Product[Productcode])<10,

    "Product : "& if(

        hasonevalue(‘Product[Productcode]),

        selectedvalue(' Product[Productcode]), 

        concatenatex('Product,'Product[Productcode],",")

    ),

"All Products"

)

[johnt75]

Try

Title text =
VAR NumSelectedProducts =
    COUNTROWS ( ALLSELECTED ( 'Product' ) )
VAR NumAllProducts =
    COUNTROWS ( ALL ( 'Product' ) )
VAR Result =
    IF (
        NumSelectedProducts = NumAllProducts,
        "All products",
        CONCATENATEX ( 'Product', 'Product'[Product code], ", " )
    )
RETURN
    Result