topic Re: Concatenated Tooltip in Quick Measures Gallery

Concatenated Tooltip

devinknight — Thu, 27 Apr 2017 20:59:54 GMT

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

Re: Concatenated Tooltip

Wouter — Thu, 04 May 2017 13:14:20 GMT

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],
“, ”
)
)
)

Re: Concatenated Tooltip

devinknight — Thu, 04 May 2017 13:39:00 GMT

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.