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 that case it's blank).

 

I have a fact table which shows:

- customer code

- other data not important for this question

 

I created a report which shows all relevant data for a customer using a slicer which is based on customer name. Standard stuff.

 

I would like to add a table to the page which basically shows all customers that belong to the same group.

Obviously when I do that now I only see one line being the customer that I selected

When I edit interactions and remove the filter, it shows all customers.

 

The desired outcome should be something like this:

 

 

Any ideas?

  • 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

     

2 Replies

  • 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