Using a Slicer to select multiple items

[Anonymous]

I have a simple line graph that shows the speed of 3 seperate pumps over a period of time. I want to input a slicer or filter, where i can click to select which of the pumps to be presented on the graph. Right now, the only way is to remove the data points from the "values" table. You can see that I have HWP1spd, HWP2spd, and HWP3spd, how can I insert a slicer or filter where i can easily go to and fromdifferent selections of the data to be shown?

[Anonymous · Accepted solution]

I think this is why i cant do it is the way my tables are setup. I can tranverse them to have the pumps in column A but then the "timeline" goes to row 1 and i would be able to show this on a graph for a period of time.

[Anonymous · Accepted solution]

I think this is why i cant do it is the way my tables are setup. I can tranverse them to have the pumps in column A but then the "timeline" goes to row 1 and i would be able to show this on a graph for a period of time.

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

According to your screenshot, I suggest you to try "Unpivot" function to transform your table. Select three columns you add in value field in your visual and then use "Unpivot" in Power Query Editor. Then you can add this column into Legend function and create a slicer by this column to select the pumps you want to show in your visual.

For reference: Unpivot columns

Best Regards,
Rico Zhou

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

[TheoC]

@Anonymous how is your data structured (can you send snippet of the table)?