Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi, community,
I have a column with teams involved in a project. It can be one or many teams such as:
Project Teams |
A |
A, B, C |
A, C |
B, C |
B |
C |
I want to build a slicer that would have A, B, C as a selection and find all projects where a team takes part in, even though it is not the only team.
Thanks
Evan
Solved! Go to Solution.
Hi, @EBGAL
I am not sure if I understood your question correctly, but I suggest transforming the table like CASE A below.
However, in case if you cannot transform the table, I also mentioned CASE B below.
Please check the below picture and the sample pbix file's link down below.
All measures are in the sample pbix file.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @EBGAL
I am not sure if I understood your question correctly, but I suggest transforming the table like CASE A below.
However, in case if you cannot transform the table, I also mentioned CASE B below.
Please check the below picture and the sample pbix file's link down below.
All measures are in the sample pbix file.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Jihwan_Kim ,
Thanks for your solution, case B worked for me as I can't transform the table to apply case A.
Thanks
Evan
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
143 | |
111 | |
108 | |
99 | |
95 |