Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using a Slicer to select multiple items

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?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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.

3 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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.