Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

slicers

Hi Everyone, I have country column and Manager column as below i want to create  slicer for country column and table for Manager when i use select all or multiple selections in slicer then it...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Anonymous selectedvalue will return value when one manager is available otherwise it returns blank, you can change your measure as below:

 

Measure = IF(ISFILTERED('Table'[Country Name]),
CONCATENATEX ( VALUES ( 'Table'[Manager]), 'Table'[Manager], "," ),
"None")

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi parry2k,

Thanks for the solution how can i get values row wise insted all the values in one row link below