Concatenated Tooltip

Frequent Visitor
3409 Views
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎06-24-2015

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

)

Attachment
Regular Visitor
Posts: 28
Registered: ‎09-18-2015

Re: Concatenated Tooltip

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

Frequent Visitor
Posts: 7
Registered: ‎06-24-2015

Re: Concatenated Tooltip

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.