Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Dynamic Title According to Multiple Selectors

Dear friends, how are you? I have the following dynamic title, and I configured it in such a way that if I have in the "Channel" field the options "Retail" and "Institutions" are selected, the resul...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Problem solved:

This is the DAX

Graphic Title = "Sales"&SELECTEDVALUE(Total[Brand (CeBe)])&" in "&SELECTEDVALUE('Metrics'[Metric])&" "&
SWITCH(TRUE(),
SELECTEDVALUE(Total[Canal])="Retail","canal Retail",
SELECTEDVALUE(Total[Canal])="Institutions","Institutions Channel",
SELECTEDVALUE(Total[Canal])="","",
"Retail and Institutions")
&" "&SWITCH(TRUE(),
SELECTEDVALUE(Total[Country])="National","National",
SELECTEDVALUE(Total[Country])="International","International",
"")