Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

slicers

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 opera...
Tips and Tricks
  • MFelix's avatar
    MFelix
    7 years ago

    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

  • MFelix's avatar
    MFelix
    7 years ago
    How do you have the slicer table setup?

    Do not make any relationship with your data table.

    Regards,
    MFelix
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Still no luck, followed video to the letter and still only get the table and slicer to work in harmony - the chart remains unaffected my slicer selections.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous ,

 

Can you share a sample of your file please?

 

If the information is sensitive please shared it trough private message.

 

Regards,

MFelix