Forum Discussion
Slicer
- 5 years ago
@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 , This one is tricky.
if the line is because of legend, create a slicer on the legend
So you need control multiple lines with the slicer
line 1 measure =
var _max =maxx(Filter(allselected(Slicer[value]),Slicer[value] ="Line1"), [Value])
return
if(_max = null , blank(), [measure])
line 2 measure =
var _max =maxx(Filter(allselected(Slicer[value]),Slicer[value] ="Line2"), [Value])
return
if(_max = null , blank(), [measure])
if need one line at a time , refer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115