devinknight's avatar
devinknight
Icon for Advocate II rankAdvocate II
9 years ago

Concatenated Tooltip

Concatenated Tooltip

This quick measure allows you to enhance your visual's tooltip, allowing you to display a list of values in a comma separated list.

 

Subcategories and More =

VAR SubcategoriesCount = DISTINCTCOUNT('Stock'[Subcategory])

RETURN

IF(SubcategoriesCount>=3,

Calculate(CONCATENATEX(TOPN(3, VALUES('Stock'[Subcategory])), 'Stock'[Subcategory], ", "))&" and more...",

CALCULATE(CONCATENATEX(VALUES(Stock[Subcategory]), 'Stock'[Subcategory],", "))

)

Other

2 Replies

  • Wouter's avatar
    Wouter
    Icon for Resolver I rankResolver I
    9 years ago

    Or like Rob Collie showed...

     

    like this

     

    [Selected]:=

    IF(NOT(ISFILTERED(Products[Subcategory])),”All”,
    IF(COUNTROWS(ALLSELECTED(Products[Subcategory]))>5, “> 5 Subcategories”,
    CONCATENATEX(
    ALLSELECTED(Products[Subcategory]),
    Products[Subcategory],
    “, ”
    )
    )
    )

    • devinknight's avatar
      devinknight
      Icon for Advocate II rankAdvocate II
      9 years ago

      Hi Wouter. Interesting... Is there an added benefit of doing it this way. Seems more complex than it needs to be but maybe there's a benefit I'm not immediately seeing.