Forum Discussion
Slicer
@colourfullife
Yes, it is possible. Since you have a measure for each line in the graph, create a table using the Enter Data option on the Home ribbon. Enter All the measure names that you use in the charts. Insert a slicer and drop the measure names.
Modify each measure to check if the particular measure is selected in white, this way you can select what to display on the chart.
You can even select multiple measures.You can download the file : https://1drv.ms/u/s!AmoScH5srsIYgYYwi9h4WbIw8meNxw?e=cRbXdT
________________________
If my answer was helpful, please consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this🙂🙂
Anonymous
Here is one way of doing this.
1) create a new table with the names of your measures by selecting the "Enter Data" option in the Home tab in the ribbon. For my example I'm working with 4 measures, so here is my new table (I've called it 'Slicer by measure'):
2) now create a new measure which will deliver the measure based on the selection made in the new slicer:
Selected Measure by Slicer = SWITCH(TRUE(),
SELECTEDVALUE('Slicer by measure'[Name Measure]) IN {"Sales for 1A"}, [Sales for 1A],
SELECTEDVALUE('Slicer by measure'[Name Measure]) IN {"Sales for 2B"}, [Sales for 2B],
SELECTEDVALUE('Slicer by measure'[Name Measure]) IN {"Sales for 3C"}, [Sales for 3C],
[Sales for 4D])
3) Create you line chart using this last measure, [Selected Meaure by Slicer], add the slicer to the page, and you get this:
PaulDBrown Thanks for your reply.
one question, can i put 2 lines in the graph using the filter?