Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problems with slicer

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 prob...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    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

dwh's avatar
dwh
Helper II
4 years ago

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