slicers

[Anonymous]

Hi, I have created a very simle line chart with time on the x horizontal axis and quatity on the y vertical axis.  I have three data sets showing three separate lines - how do I get a slicer to operate on the three data lines ie able to select which or how many lines are shown?  Any help appreciated.

[MFelix · Accepted solution]

Hi @Anonymous ,

You measures for each column should be something like this:

Measure G = 
IF (
    CONTAINS ( MeasuresSelection; MeasuresSelection[Measure]; "Measure G" );
    SUM ( Table1[G] );
    BLANK ()
)

Measure M =
IF (
    CONTAINS ( MeasuresSelection; MeasuresSelection[Measure]; "Measure M" );
    SUM ( Table1[M] );
    BLANK ()
)

Then add this measures to your chart and the slicer based on the measure selection table.

See attach PBIX file.

Regards,

Mfelix