Forum Discussion
Multiple column selection in one table with slicer
Hi All,
I am trying to create a table with one column with a combination of multiple column selection with a slicer
Example :
columns :
Test Eye = Test Eye A, Test Eye B, Test Eye C, Test Eye D
Test Nose = Test Nose A, Test Nose B, Test Nose C, Test Nose D
Test Mouth = Test Mouth A, Test Mouth B, Test Mouth C, Test Mouth D
When A is selected from Slicer, table will show values from Test Eye A, Test Nose A and Test Mouth A
Any suggestions would be really appreaciated.
Regards,
RR
Hi ravindranraman ,
Please refer to this post.
There's a potential solution in it and also a pbix file attached for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Ashish_Mathur
Super User
Hi,
Unpivot your dataset and using Column from Examples, extract A,B,C and D to another column. Use the extracted data as a slicer.
Will this work as i have a large set of data with multiple columns?
I was trying this but it only picks up one expression
CALCULATE(FIRSTNONBLANK(Table1[_Test Eye A],Table1[_Test Eye A]),
FIRSTNONBLANK(Table1[_Test Nose A],Table1[_Test Nose A]),
FILTER(Table1,Table1[_Test Eye A]=SELECTEDVALUE(Slicer[Slicer])||(Table1[_Test Nose A]=SELECTEDVALUE(Slicer[Slicer])))))
Hi ravindranraman ,
Please refer to this post.
There's a potential solution in it and also a pbix file attached for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
