Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Have slicer options filtered based off empty data in another table.

Hey All, 

 

I currently have two tables. One which has all the details of projects based off a project number. The second table has a list of only the projects that have been exported and can be used for the reporting. At the moment when I add the 'Project' column to the slicer it shows every project even though many are empty. How do I set up a filter or measure so it only shows the project name of those projects which have been exported to the second table. I know I could add a column easily to the second table to put the project name but this messes with other filters on the page and reduces what projects can be seen. I ideally need a way of filtering out the current table I'm using to purely show lines related to the other table, rather than editing or changing either of the tables.

 

In the photo below you can see there is a 'Project' slicer and a 'Group/Database' slicer. I need the group/database slicer to not filter the projects but the projects to filter the groups/database also. Currently this works when using the 'Projects' column in the currently used table but not when using the job number from the other table.

 

           

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Anonymous ,

    I created some data:

    Table1：

    Table2：

    Use Table1's [Project] and [Group/Database] as slicers.

    Here are the steps you can follow：

    1. Create measure.

    Flag =
VAR _SLEECT=SELECTCOLUMNS('Table2',"project",[Project])
return
IF(
    MAX('Table'[Project]) in _SLEECT,1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    I created some data:

    Table1：

    Table2：

    Use Table1's [Project] and [Group/Database] as slicers.

    Here are the steps you can follow：

    1. Create measure.

    Flag =
VAR _SLEECT=SELECTCOLUMNS('Table2',"project",[Project])
return
IF(
    MAX('Table'[Project]) in _SLEECT,1,0)

    2. Place [Flag]in Filters, set is=1, apply filter.

    3. Result:

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi,

    if you are looking for the one of the slicer should not filter the other slicer then you can use "Edit Interactions" option.

     

    Choose the project slicer and disable the selection for the other slicer.

     

    Thanks

    Hari