Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have one table with multiple columns with false/true values. I'm trying to create a slicer that will filter all of the columns by linking a seperate table with the values true/false but having problems.
These are my columns with the false/true values:
This is my table for the slicer:
This is how I've connected the two tables:
The result I'm looking for is that I want to filter all true values or all the false values for all the tables, however I can't make it work.
Solved! Go to Solution.
Hi @hiral ,
Try to create a similar calculated column and use it as a field for the slicer.
Kontroll =
SWITCH (
TRUE (),
'Table'[Column1] = "True"
&& 'Table'[Column2] = "True"
&& 'Table'[Column3] = "True"
&& 'Table'[Column4] = "True", "TRUE",
'Table'[Column1] = "False"
&& 'Table'[Column2] = "False"
&& 'Table'[Column3] = "False"
&& 'Table'[Column4] = "False", "FALSE",
BLANK()
)
Sieve out the blanks in the slicer.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
I would do one other thing.
I would create a registry for each combination of control and data.
So column 1 = control, column2 = guid, column3 = etc.
This is for each table. By doing so you have the personal data of each one. Then I would create a Control table (true / false).
Finally, I would connect the control file with each registry table and each registry with the main table.
In all this it is enough to decide on a key or create a connection key (for example a key can be GUID + Kontrol)
I hope I was clear
Hi @hiral ,
Try to create a similar calculated column and use it as a field for the slicer.
Kontroll =
SWITCH (
TRUE (),
'Table'[Column1] = "True"
&& 'Table'[Column2] = "True"
&& 'Table'[Column3] = "True"
&& 'Table'[Column4] = "True", "TRUE",
'Table'[Column1] = "False"
&& 'Table'[Column2] = "False"
&& 'Table'[Column3] = "False"
&& 'Table'[Column4] = "False", "FALSE",
BLANK()
)
Sieve out the blanks in the slicer.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |