slicers

[Anonymous]

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 must  show specific text like "None" or "select only single values". when i select single value in selection then table must show all the managers for the selected country.

I have created below measure but this is not working when i select country JAPAN or Australia as both countries have multiple managers

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

[parry2k · Accepted solution]

@Anonymous I think this is what you are looking for, follow this post.

✨ 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]

@parry2k  Thanks  for providing the solution. It's working for me 

[parry2k]

@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]

Hi @parry2k,

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