Forum Discussion
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 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
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.⚡
4 Replies
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.⚡
Hi parry2k,
Thanks for the solution how can i get values row wise insted all the values in one row link below
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.⚡
parry2k Thanks for providing the solution. It's working for me