Forum Discussion

austmiller5's avatar
austmiller5
New Member
3 years ago
Solved

Isolating slicer dropdown multiple selections to create a graph with just that item's data

Hello,

 

I am trying to use the Slicer Multiple Selection tool to filter my data and graphs. However, when I select multiple items in my dropdown, all the data is populated on a single graph. Is there a way to isolate each selected item from the dropdown and create a graph with just that item's data? See the example below.

 

Thanks!

Example

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  austmiller5 ,

    I created some data:

    Option_Table：

    Table：

     

    Here are the steps you can follow：

    1. Create measure.

    Flag_Option1 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option1" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option2 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option2" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option3 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option3" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option4 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option4" &&MAX('Table'[Option]) in _select,1,0)

    2. Place the above 4 Measures into the Filter belonging to their respective Visuals, and set them equal to 1..

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  austmiller5 ,

    I created some data:

    Option_Table：

    Table：

     

    Here are the steps you can follow：

    1. Create measure.

    Flag_Option1 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option1" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option2 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option2" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option3 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option3" &&MAX('Table'[Option]) in _select,1,0)
    Flag_Option4 =
var _select=SELECTCOLUMNS('Option_Table',"Option",'Option_Table'[Option])
return
IF(
    MAX('Table'[Option]) = "Option4" &&MAX('Table'[Option]) in _select,1,0)

    2. Place the above 4 Measures into the Filter belonging to their respective Visuals, and set them equal to 1..

    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