Forum Discussion

lekkerbek's avatar
lekkerbek
Helper IV
1 year ago
Solved

Help ignoring a slicer

Hi,   I have a question about ignoring a slicer.   I have a dim table which shows: - customer code - customer name - customer group   Multiple customers can be part of 1 group or not (in tha...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi lekkerbek 

     

    The easiest way to do this is duplicate the customer and group column into a seperate table.

    Don't join this on to your existing table and then put that in your slicer.

     

    Then you can create a measure to filter the data.

    Add the measure into your Filter Pane under Filters on this visual.

     

    filter measure =
    var curr =SelectedValue(table[duplicated customer group])

    Return
    IF( SelectedValue(table[original customer group]) = curr, "Y")

    Then filter this to Y

     

SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi lekkerbek 

 

The easiest way to do this is duplicate the customer and group column into a seperate table.

Don't join this on to your existing table and then put that in your slicer.

 

Then you can create a measure to filter the data.

Add the measure into your Filter Pane under Filters on this visual.

 

filter measure =
var curr =SelectedValue(table[duplicated customer group])

Return
IF( SelectedValue(table[original customer group]) = curr, "Y")

Then filter this to Y

 

lekkerbek's avatar
lekkerbek
Helper IV
1 year ago

Works like a charm. Thanks a million!