Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 columns, and I need an intelligent filter that can select types only when a condition is met.
Color Type
Blue A,B
Brown A,D
Red C,B
Yellow A,B,C
The model that I have was splitted in this way:
Color Type
Blue A
Blue B
Brown A
Brown D
Red C
Red B
Yellow A
Yellow B
Yellow C
If I select A, C, D, the result should be:
Color Type
Brown A,D
But my result using a Slicer is
Color Type
Blue A,B
Brown A,D
Red C,B
Yellow A,B,C
Could you please help me to find a solution?
Solved! Go to Solution.
Hi @Anonymous ,
I change something in my sample, you could try to use measure 8 for your sample(or you could use measure 6), and manually change table 3(beacuse it sort wrong when use values (table)). You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Color Type
Blue A,B
Brown A,D
Red C,B
Yellow A,B,C
Hi Zoe,
Thanks for the help, I really appreciate it. I checked the pbxi and is really impressive. I have a question, what happen if I have to select a different combination, for example: If I have to select B,C? The results should be:
Red C,B
Yellow A,B,C
If I have to select A, B? The results should be:
Blue A,B
Yellow A,B,C
That is the result that I need.
Thanks for the help,
Arthur
Hi @Anonymous ,
I change something in my sample, you could try to use measure 8 for your sample(or you could use measure 6), and manually change table 3(beacuse it sort wrong when use values (table)). You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Incredible solution, thanks💪
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.