Slicer based on several columns

[Anonymous]

I have a base data looking like the following: (been unpivoted).

Order may come from several sources, shown, but I want to be able to select which channel I need and see orders for that channel.

How can I do this?

In the case following, I see something like a slicer, where i select adwords, or cc and see orders for that channel

[Anonymous · Accepted solution]

Hi, @Anonymous 

Thanks for Selva-Salimi's suggestion. You can use Filed Parameter to generate the Slicer and then create the flag measure.

Measure:

flag =
VAR _selectedSlicer =
    SELECTEDVALUE ( Parameter[Parameter Fields] )
VAR _switchSelectedSlicer =
    SWITCH (
        _selectedSlicer,
        "'Table'[from_adwords]", "adwords",
        "'Table'[from_blogger]", "blogger",
        "'Table'[from_cc]", "cc",
        "'Table'[from_mail]", "email",
        "'Table'[from_organic]", "organic",
        "'Table'[from_social]", "social",
        BLANK ()
    )
VAR _current_from_adwords =
    SELECTEDVALUE ( 'Table'[from_adwords] )
VAR _current_from_blogger =
    SELECTEDVALUE ( 'Table'[from_blogger] )
VAR _current_from_cc =
    SELECTEDVALUE ( 'Table'[from_cc] )
VAR _current_from_mail =
    SELECTEDVALUE ( 'Table'[from_mail] )
VAR _current_from_organic =
    SELECTEDVALUE ( 'Table'[from_organic] )
VAR _current_from_social =
    SELECTEDVALUE ( 'Table'[from_social] )
VAR _result =
    SWITCH (
        TRUE (),
        _switchSelectedSlicer = _current_from_adwords, 1,
        _switchSelectedSlicer = _current_from_blogger, 1,
        _switchSelectedSlicer = _current_from_cc, 1,
        _switchSelectedSlicer = _current_from_mail, 1,
        _switchSelectedSlicer = _current_from_organic, 1,
        _switchSelectedSlicer = _current_from_social, 1,
        BLANK ()
    )
RETURN
    _result

Best Regards,
Yang
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 in the Power BI Forum

[Selva-Salimi]

Hi @Anonymous 

you can add your expected columns under each other to have a hierarchy slicer. Like following:

 

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Selva-Salimi thank you for the help, but this suggestion lost me. When I do a hierarchy slicers it looks like that:

And I just want a tile "adwords" "cc", "mail"

[Selva-Salimi]

@Anonymous 

I think there was a misunderstanding. would you please share an example of your expectation?! I am not sure but I think you might have a unique order number for each edward, bloger, cc, mail,... and would like to show them in slicer and as you select in the drop down can see order number?! if so, would you unpivot your table?!

[Anonymous]

Hello @Selva-Salimi , thanks for that.

I have a similar slicer in mind like the one below: so I pick which channel / team to filter and get turnover and other metrics like in a table filtered for that team.

The problem I have is that channels / teams come from separate columns (like in screenshot earlier) and I don't know how to make them into a structure below

[Selva-Salimi]

@Anonymous 

I think you need which contains your column names and an ID to simply manage as follows: (named team_table)

1	Team_Blogger
2	Team_CC
3	Team_email
...	...

and use this table in your slicer. this table should not have any relationship with others. then write a measure as follows:

measure related_Ids := var selected_team= values( team_table [ID])

return

if({1} in selceted_team , if ( your_table [from_blogger] = Blank() , 0 , 1) , if {2} in selected_team , if ( your_table [from_cc] = blank() , 0,1) ,......)

and add this measure to visual level filter and set it to 1.

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.