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
MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Send a web link for onedrive, google drive, we transfer or similar.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

https://lloydsregistergroup-my.sharepoint.com/:x:/g/personal/stuart_ainsworth_lr_org/EfgLBZTB5ZBMpw5I3nztVlIB1jH5QZeGVUlqRw_DORGy0Q?e=MzbcOZ

 

Very basic data set, I then created 2 new measures to copy the initial data and allow the CONTAINS amendment to be made.  I set up the xTable as instructed but only the slicer (xTable) and the table visualisation are changed when using the slicer. 

 

https://lloydsregistergroup-my.sharepoint.com/:u:/g/personal/stuart_ainsworth_lr_org/EeJWKtI2QRFElfKl2PjAD6wBsIchB4A06AcUR_CFTlov8g?e=hx9aVQ

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Anonymous ,

     

    This is pointing to a closed sharepoint group (probably from your company) don't have access to the file.

     

    Regards,

    MFelix