Forum Discussion
Slicer using multiple field
Hello,
I need to have a slicer with options : X and Y.
I have a table like this :
Name | Transport | Network |
A | Toto | 1 |
B | Tata | 1 |
C | Toto | 3 |
X : if transport = Toto
Y : if Network = 1
But, if I use IF loop I have this :
Name | Transport | Network | Slicer |
A | Toto | 1 | X,Y |
B | Tata | 1 | Y |
C | Toto | 3 | X |
So, I can't use that in slicer. I would like only two choices and for A crossjoin in order to display A,B or B,C according to my filter.
Do you have any idea to do that ?
Thanks in advance
Hi Anonymous ,
Please try the way below.
Firstly unpivot Transport and Network columns in Query Editor.
Then create the calculated column like below.
Column = IF('Table'[Value]="Toto","X",IF('Table'[Value]="1","Y"))Then you could use column as a slicer.
Best Regards,
Cherry
Hi Anonymous ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
2 Replies
Hi Anonymous ,
Please try the way below.
Firstly unpivot Transport and Network columns in Query Editor.
Then create the calculated column like below.
Column = IF('Table'[Value]="Toto","X",IF('Table'[Value]="1","Y"))Then you could use column as a slicer.
Best Regards,
Cherry
Hi Anonymous ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry