Forum Discussion

FDYBI's avatar
FDYBI
Frequent Visitor
4 years ago
Solved

Help setting up a Slicer / Filter with AND logic selecting from one field and filtering another.

I may not be explaining it very well, I'm finding it hard to actually describe what I'm trying to do.  I have a set of 'Types' and 'Sub Types' associated with various reports.  The each report may ha...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi FDYBI ,

    Please refer to my pbix file to see if it helps you.

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjI0MjRW0lGKjAQREUqxOgixiAgQEQkXM8EiZgoTQ9JrCjMPpC4WAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [report = _t, #"type" = _t, #"sub-type" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"report", Int64.Type}, {"type", type text}, {"sub-type", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"report"}, {{"Count", each Text.Combine([type], ","),type text}, {"subtype", each Text.Combine([#"sub-type"],","),type text}})
in
    #"Grouped Rows"

     

    If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.

    How to Get Your Question Answered Quickly 

     

    Best Regards

    Community Support Team _ Polly

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi FDYBI ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Best Regards

Community Support Team _ Polly

 

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

  • FDYBI's avatar
    FDYBI
    Frequent Visitor
    4 years ago

    It made sense for grouping; however, I did that myself through the initial bringing in of the data in power query.  I have no issue with concatenating the data into new columns.  What I'm having an issue with is creating a slicer, or slicers, to perform with an AND logic so someone can click on multiple types and show if and it contains the item selected AND another item selected.  Ie: a slicer / selectable filter that you can click "XX" AND "YY" and it will show you 21213 and 21215 in your example but not 21214.