Concatenated Tooltip 05-04-2017 06:39 AM

[devinknight]

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

)

eyJrIjoiOTNkY2Y1MmQtY2Y0Ni00MGY1LTkzYTItMzBlNDIxZTVkMzhiIiwidCI6IjBhYTVjODNjLTkzZjMtNGY0ZC1hNzJmLTdiZTkzMDkxOTZhNiIsImMiOjN9

[Wouter]

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]

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.