Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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],
“, ”
)
)
)
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.